RE: schema default privilege owner not showing

Поиск
Список
Период
Сортировка
От Andrew Terry
Тема RE: schema default privilege owner not showing
Дата
Msg-id AM6PR01MB49466DC17B3E2996D16DC308A1230@AM6PR01MB4946.eurprd01.prod.exchangelabs.com
обсуждение исходный текст
Ответ на Re: schema default privilege owner not showing  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Список pgadmin-support
Дерево обсуждения

Hi,

 

Thanks – good to know it’s valid and will hopefully get updated in the future.

 

Cheers

 

Andy

 

===================

 

Hi,

 

This issue has already been logged.  Ref: https://redmine.postgresql.org/issues/4256

 

Thanks,

Khushboo

 

On Fri, Sep 11, 2020 at 5:45 PM Andrew Terry <andrew.terry@centremaps.co.uk> wrote:

Hi,

 

Trying out assigning privileges such as:

 

ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;

ALTER DEFAULT PRIVILEGES FOR ROLE usr_1 IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;

ALTER DEFAULT PRIVILEGES FOR ROLE usr_2 IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;

 

When viewing the pgadmin “SQL” tab for the “schemaname" schema, all of these just show as:

 

ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;

ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;

ALTER DEFAULT PRIVILEGES IN SCHEMA schemaname GRANT SELECT ON TABLES TO grp_read;

 

As such, it’s not possible to tell the difference and which role these are assigned to.

 

\ddp schemaname in psql seems to show “Owner” for Default access priveleges – I don’t know whether this could be read into the SQL tab?

 

For reference – i’m setting by user but was also hoping to set just by a group (grp_read) role but that doesn’t seem to be possible

 

Thanks in advance

 

Andy

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