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? Achilleas Mantzios <achill@matrix.gatewaynet.com>
Re: How to revoke "Create Privilege" from a readonly user in postgres? Shreeyansh Dba <shreeyansh2014@gmail.com>
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? Rui DeSousa <rui@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? Rui DeSousa <rui@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? Rui DeSousa <rui@crazybean.net>
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 по дате отправления
От: pavan95
Дата:
