[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