Make grant all on all tables in schema x persistent for new tables

Поиск
Список
Период
Сортировка
Искать

Make grant all on all tables in schema x persistent for new tables

От:
"S. Bob" <sbob@quadratum-braccas.com>
Дата:
All;


I can run a GRANT ALL ON ALL TABLES in SCHEMA X to USER Y

which of course grants all privileges to the user Y on all tables in 
schema X

How do I make this the default permission for all future tables created 
in schema X as well?


Thanks in advance



Re: Make grant all on all tables in schema x persistent for new tables

От:
Steven Crandell <steven.crandell@gmail.com>
Дата:
On Mon, Feb 18, 2019 at 12:09 PM S. Bob <sbob@quadratum-braccas.com> wrote:
All;


I can run a GRANT ALL ON ALL TABLES in SCHEMA X to USER Y

which of course grants all privileges to the user Y on all tables in
schema X

How do I make this the default permission for all future tables created
in schema X as well?


Thanks in advance



Take a look at default privileges here: 

Re: Make grant all on all tables in schema x persistent for newtables

От:
MirrorX <mirrorx@gmail.com>
Дата:
you can use the 'alter default privileges' command and grant whatever
permission you want to a user by default when a new table is created -> 
https://www.postgresql.org/docs/9.4/sql-alterdefaultprivileges.html



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

FAQ