[lug] postgres question
dan at radom.org
Wed Nov 12 19:40:41 MST 2003
* 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
> This time when I do it, I find that it hasn't granted me privileges to
> 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
will show you the permissions. grant all on db to user; should get it.
More information about the LUG