Thread: pgAdminIII and User Grants

i'm trying to grant a user permissions in pgadminiii.
however, the only option it gives me is for the group
"public".

in addition, i can grant privileges at the db level,
the schema level, the public schema level, the generic
table level and the specific table level.

no choice allows a single user to have privileges
added and it isn't at all clear to me what levels i
need to grant privileges since i have 5 choices.

any advice w/b appreciated.

tia...



__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail

At the moment there is no way to do that in pgadmin or anything else.

On Mon, Jan 31, 2005 at 07:25:56AM -0800, operationsengineer1@yahoo.com wrote:
> i'm trying to grant a user permissions in pgadminiii.
> however, the only option it gives me is for the group
> "public".
>
> in addition, i can grant privileges at the db level,
> the schema level, the public schema level, the generic
> table level and the specific table level.
>
> no choice allows a single user to have privileges
> added and it isn't at all clear to me what levels i
> need to grant privileges since i have 5 choices.
>
> any advice w/b appreciated.
>
> tia...
>
>
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Mail - Helps protect you from nasty viruses.
> http://promotions.yahoo.com/new_mail
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

operationsengineer1@yahoo.com wrote:
 > i'm trying to grant a user permissions in pgadminiii.
 > however, the only option it gives me is for the group
 > "public".

Go to File > Options > Preferences, check the checkbox next to "Show
users for privileges?" and click on OK. Now you should see the
individual database users in the privileges dialogs.

 > in addition, i can grant privileges at the db level,
 > the schema level, the public schema level, the generic
 > table level and the specific table level.
 >
 > no choice allows a single user to have privileges
 > added and it isn't at all clear to me what levels i
 > need to grant privileges since i have 5 choices.

What are you trying to achieve?

Cheers,

Alex