From: | durumdara <durumdara(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | PGAdmin and user privileges - what I do wrong? |
Date: | 2009-02-04 12:40:08 |
Message-ID: | 49898CA8.5040201@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2009-02-04 12:47:43 | Re: PGAdmin and records as inserts (like in SQLyog) |
Previous Message | durumdara | 2009-02-04 12:31:10 | PGAdmin and records as inserts (like in SQLyog) |