From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | developer(at)wexwarez(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: grant all privileges on database |
Date: | 2006-12-13 21:02:53 |
Message-ID: | 45806A7D.7070305@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
developer(at)wexwarez(dot)com wrote:
> grant all privileges on database test to auser
>
> As far as I can tell this does nothing. Intuitively this command suggests
> that the auser would be able to access and modify the database test in
> anyway. It would also suggest that as new tables for the database auser
> would automatically have access to them.
>
>
It just grants all privileges for a database object to auser.
You should check out the grant manager in Lightning Admin for
Postgresql, it visually shows everything and makes
it a bitter easier to see how it works.
http://www.amsoftwaredesign.com/onlinehelp/pgla/grant_manager.htm
In the screenshot the cells that are green are the ones that can be set
for a particular object, and for a database it's just
two. So the grant statement you used above did indeed do something, but
only for a database object.
Hope this helps.
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
Only $9.99 through January 1st 2007
From | Date | Subject | |
---|---|---|---|
Next Message | Ben | 2006-12-13 21:10:44 | a question for the way-back machine |
Previous Message | Bricklen Anderson | 2006-12-13 20:51:49 | Re: plperl exception catching |