[lug] postgres question

Hugh Brown hugh at math.byu.edu
Wed Nov 12 18:59:52 MST 2003


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"

Any ideas?




More information about the LUG mailing list