[lug] postgres question

Hugh Brown hugh at math.byu.edu
Wed Nov 12 21:26:48 MST 2003

On Wed, 2003-11-12 at 21:40, dan radom wrote:
> * Hugh Brown (hugh at math.byu.edu) wrote:
> > I am doing something that I could swear I've done a number of times.
> > 
> > As user postgres I create a user and a database.  Then as postgres I run
> > GRANT ALL ON DATABASE newdb TO newuser;
> > 
> > In the past, that has been sufficient to give newuser privileges on
> > everything.
> > 
> > This time when I do it, I find that it hasn't granted me privileges to
> > anything.
> > 
> > newuser connects, tries a select and it fails with a permission denied.
> > 
> > It seems terribly stupid to have GRANT ALL ON DATABASE do absolutely
> > noting except print "GRANT"
> > 
> pdel -s newdb
> newdb=#\dp
> will show you the permissions.  grant all on db to user; should get it.
> dan

I tried that.  No perms show up.  I think all that grant all on database
allows you to do is create new tables, new views, new triggers etc.

So, apparently in the past I have populated as the new user, not as
postgres and then a grant all.  Disappointing command.


More information about the LUG mailing list