pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Make grant all on all tables in schema x persistent for new tables
3+ messages / 3 participants
[nested] [flat]

* Make grant all on all tables in schema x persistent for new tables
@ 2019-02-18 19:09 S. Bob <sbob@quadratum-braccas.com>
  2019-02-18 19:11 ` Re: Make grant all on all tables in schema x persistent for new tables Steven Crandell <steven.crandell@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: S. Bob @ 2019-02-18 19:09 UTC (permalink / raw)
  To: pgsql-admin

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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Make grant all on all tables in schema x persistent for new tables
  2019-02-18 19:09 Make grant all on all tables in schema x persistent for new tables S. Bob <sbob@quadratum-braccas.com>
@ 2019-02-18 19:11 ` Steven Crandell <steven.crandell@gmail.com>
  2019-03-01 14:56   ` Re: Make grant all on all tables in schema x persistent for new tables MirrorX <mirrorx@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Steven Crandell @ 2019-02-18 19:11 UTC (permalink / raw)
  To: S. Bob <sbob@quadratum-braccas.com>; +Cc: pgsql-admin

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:
https://www.postgresql.org/docs/current/sql-alterdefaultprivileges.html

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Make grant all on all tables in schema x persistent for new tables
  2019-02-18 19:09 Make grant all on all tables in schema x persistent for new tables S. Bob <sbob@quadratum-braccas.com>
  2019-02-18 19:11 ` Re: Make grant all on all tables in schema x persistent for new tables Steven Crandell <steven.crandell@gmail.com>
@ 2019-03-01 14:56   ` MirrorX <mirrorx@gmail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: MirrorX @ 2019-03-01 14:56 UTC (permalink / raw)
  To: pgsql-admin

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2019-03-01 14:56 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-02-18 19:09 Make grant all on all tables in schema x persistent for new tables S. Bob <sbob@quadratum-braccas.com>
2019-02-18 19:11 ` Steven Crandell <steven.crandell@gmail.com>
2019-03-01 14:56   ` MirrorX <mirrorx@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox