Re: Re: Group role not shown in properties > Default Privileges after adding it

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: Re: Group role not shown in properties > Default Privileges after adding it
Дата
Msg-id CA+OCxoydJAOZawXg1O2ZFVgF0O_hX9B8UxgS0tzLwzn9e-5Few@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Group role not shown in properties > Default Privileges after adding it  (Aren Cambre <aren@arencambre.com>)
Ответы Re: Re: Group role not shown in properties > Default Privileges after adding it
Список pgadmin-support


On Mon, May 28, 2012 at 10:39 AM, Aren Cambre <aren@arencambre.com> wrote:
Looks like pgAdmin's user handling is broken or nonsensical. Just as a test, I created a new login role named test. Here's its SQL:
CREATE ROLE test LOGIN
  ENCRYPTED PASSWORD 'md505a671c66aefea124cc08b76ea6d30bb'
  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;

Then I went to the Tables section of one of a db's schemas, started the Grant Wizard, then went to the Privileges tab, and this test account doesn't appear in the Role dropdown. All I see is public. If I type in test, I can't press Add/Change no matter what I select in Privileges.

This doesn't make sense. If I create a login role, it should show up here and allow me to assign it to arbitrary tables.

That's intentional (and configurable): see http://www.pgadmin.org/support/faq.php#UserPrivileges
 

And I can confirm that pgAdmin is not acting correctly through direct SQL. If I run this:
grant select on txdot_roadways_3081_transform to gis;

(gis is the account I was trying to use earlier.) Then I can select from that table using that account via another program.'


That's what I'd expect to happen - the GRANT applies to any user interface, not just pgAdmin. 

(I'll leave the default privs stuff for Guillaume to comment on, as he wrote that and I'm not overly familiar with it and am pressed for time right now).

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

В списке pgadmin-support по дате отправления:

Предыдущее
От: Aren Cambre
Дата:
Сообщение: Re: Group role not shown in properties > Default Privileges after adding it
Следующее
От: Aren Cambre
Дата:
Сообщение: Re: Re: Group role not shown in properties > Default Privileges after adding it