Postgres Pro
Downloads
Home   >   mailing lists

Thread: PGAdmin and user privileges - what I do wrong?

PGAdmin and user privileges - what I do wrong?

From
durumdara
Date:
Hi!

Please help me a little.

I used PGAdmin to administrate my databases.
I created a new user named "zx".

CREATE ROLE zx LOGIN
   ENCRYPTED PASSWORD '*'
   NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;

When I want to manually assign this user to a table, I have problem in
the PGAdmin's Privilege tab.
The privileges GroupBox have a ComboBox, named Role. This ComboBox is
not containing the zx user in it's list.

When I write the user (zx) into the combo , then the "Add" button have
been disabled.

I can write only an SQL cmd to add this privilege. When I do it, the
Privilege list extended with this user, I can select it from the combobox.

What I do wrong? Which property I need to set to I can Add privileges to
the tables/objects with this user?

Thanks for your help:
    dd

Re: PGAdmin and user privileges - what I do wrong?

From
Raymond O'Donnell
Date:
On 04/02/2009 12:40, durumdara wrote:

> When I want to manually assign this user to a table, I have problem in
> the PGAdmin's Privilege tab.
> The privileges GroupBox have a ComboBox, named Role. This ComboBox is
> not containing the zx user in it's list.

By default, that combo box shows only group roles.

You need to go to File -> Options -> Preferences tab, and select "Show
users for privileges".

By the way, there's a separate mailing list for specifically pgAdmin
questions - pgadmin-support@postgresql.org - you'll find subscription
instructions on the pgAdmin website. This list is for PostgreSQL itself.

HTH,

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

Re: PGAdmin and user privileges - what I do wrong?

From
Dave Page
Date:
On Wed, Feb 4, 2009 at 12:40 PM, durumdara <durumdara@gmail.com> wrote:
> Hi!
>
> Please help me a little.
>
> I used PGAdmin to administrate my databases.
> I created a new user named "zx".
>
> CREATE ROLE zx LOGIN
>  ENCRYPTED PASSWORD '*'
>  NOSUPERUSER NOINHERIT NOCREATEDB NOCREATEROLE;
>
> When I want to manually assign this user to a table, I have problem in the
> PGAdmin's Privilege tab.
> The privileges GroupBox have a ComboBox, named Role. This ComboBox is not
> containing the zx user in it's list.
>
> When I write the user (zx) into the combo , then the "Add" button have been
> disabled.
>
> I can write only an SQL cmd to add this privilege. When I do it, the
> Privilege list extended with this user, I can select it from the combobox.
>
> What I do wrong? Which property I need to set to I can Add privileges to the
> tables/objects with this user?

See File -> Options -> Preferences -> Show users for privileges?

By default, only group roles are listed.

--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

Re: PGAdmin and user privileges - what I do wrong?

From
anatoly techtonik
Date:
This saved my day. Thanks!

In pgAdmin III the option it is: File -> Options... -> Browser > UI
Miscellaneous

This stuff is confusing for a beginner. I wish pgadmin III had some tooltip
or Help link to relevant chapter about "Why creating users is discouraged?".



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/PGAdmin-and-user-privileges-what-I-do-wrong-tp1913766p5776050.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.