Re: How to revoke "Create Privilege" from a readonly user inpostgres?

Поиск
Список
Период
Сортировка
От Rui DeSousa
Тема Re: How to revoke "Create Privilege" from a readonly user inpostgres?
Дата
Msg-id 2A936B5B-CF6A-41E5-B839-E6CE7EDB8CF7@crazybean.net
обсуждение исходный текст
Ответ на Re: How to revoke "Create Privilege" from a readonly user inpostgres?  (pavan95 <pavan.postgresdba@gmail.com>)
Ответы Re: How to revoke "Create Privilege" from a readonly user inpostgres?
Список pgsql-admin


On Nov 7, 2018, at 12:52 AM, pavan95 <pavan.postgresdba@gmail.com> wrote:

grant SELECT on all tables in schema  readonly to readonly;

That grants select on all existing tables to readonly user; not future tables.

To auto grant select on future tables you have to change the default privileges. 
I.e.

alter default privileges in schema readonly grant select on tables to readonly;

You can also scope it to only a user instead of anyone to creates a table in readonly schema.  Then only when xxx creates a table in schema readonly will it auto grant the select.

alter default privileges for user xxx in schema readonly grant select on tables to readonly;





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

Предыдущее
От: Ron
Дата:
Сообщение: Re: Recovery data base!!
Следующее
От: pavan95
Дата:
Сообщение: Re: How to revoke "Create Privilege" from a readonly user inpostgres?