Re: rights for schema
От | Adrian Klaver |
---|---|
Тема | Re: rights for schema |
Дата | |
Msg-id | 50E0E64C.107@gmail.com обсуждение исходный текст |
Ответ на | Re: rights for schema (Christian Hammers <ch@lathspell.de>) |
Ответы |
Re: rights for schema
Re: rights for schema |
Список | pgsql-general |
On 12/30/2012 04:06 PM, Christian Hammers wrote: > Am Sun, 30 Dec 2012 15:54:32 +0100 > schrieb Philipp Kraus <philipp.kraus@flashpixx.de>: > >> Hello, >> >> can I set all rights to a schema and its content? I have different >> schema and in the public schema all users should be do everything >> (select, update, delete, call functions, etc). Also if I add a new >> user, the user should be get also the rights. My other schemas are >> only access by the database user only. >> >> How can I do this? >> >> Phil > > AFAIK you can't set all rights for all tables, views, functions etc. > inside a schema "recursively" with one command. Neither can you say > that, inside a specific schema, every newly created table or function > should automatically get a "default" access list. > (the "template1" database can only be used to do the latter for newly > created databases). Actually as of 9.0 that is not strictly true: http://www.postgresql.org/docs/9.2/interactive/sql-alterdefaultprivileges.html -- Adrian Klaver adrian.klaver@gmail.com
В списке pgsql-general по дате отправления: