Set the permissions while creating database, schema, and tables

Поиск
Список
Период
Сортировка
От dipti shah
Тема Set the permissions while creating database, schema, and tables
Дата
Msg-id d5b05a951002142335u1554ebfex5db69a45e847c773@mail.gmail.com
обсуждение исходный текст
Ответы Re: Set the permissions while creating database, schema, and tables  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
Дерево обсуждения
Hi,

Could anyone please help me out here. I want to set the required permissions while creating PostGreSQL database, schema, and tables from stored procedures. Is it possible to do it while creating them?

I could see that "OWNER" option is there while creating database but couldn't see such option for schema or table. Please let me know if I missed out something.
 
CREATE DATABASE sales OWNER salesapp TABLESPACE salesspace;
 
With above command, can I grant permission to particular group of users?


Thanks,
Dipti

В списке pgsql-general по дате отправления:

Предыдущее
От: dipti shah
Дата:
Сообщение: Re: The easiest and robust way of configuring password pass through mechanism..
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Set the permissions while creating database, schema, and tables