| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | Yang Zhang <yanghatespam(at)gmail(dot)com> |
| Subject: | Re: Default permissions for CREATE SCHEMA/TABLE? |
| Date: | 2011-03-24 21:00:02 |
| Message-ID: | 201103241400.02596.adrian.klaver@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday, March 24, 2011 1:52:24 pm Yang Zhang wrote:
> Any way I can have all newly created schemas/tables be owned by, or
> have all permissions granted to, a certain group, without having to
> remember to GRANT ALL ON [SCHEMA|TABLE] TO that group? Thanks in
> advance.
If you are using 9.0:
http://www.postgresql.org/docs/9.0/interactive/sql-alterdefaultprivileges.html
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sven Haag | 2011-03-24 21:49:22 | Re: Recursive function that receives a list of IDs and returns all child IDs |
| Previous Message | Selena Deckelmann | 2011-03-24 20:59:29 | Re: foreign data wrappers |