Re: pgAdminIII and User Grants

operationsengineer1(at)yahoo(dot)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