Role & User - Inheritance?
От | Alexi Gen |
---|---|
Тема | Role & User - Inheritance? |
Дата | |
Msg-id | BAY21-F5C8CBFE49C33D20EC9B57AD720@phx.gbl обсуждение исходный текст |
Ответы |
Re: Role & User - Inheritance
Re: Role & User - Inheritance? |
Список | pgsql-general |
[GENERAL] Role & User - Inheritance? A ROLE dba01 has been given the option of SUPERSUSER. A USER user01 is created and tagged to the above ROLE dba01. When attempting to create a Tablespace (logged in as user01) it generates the following message: "permission denied to create tablespace (tblspc01). Must be superuser to create a tablespace.". Since user01 is tagged to dba01 (who has the SUPERUSER option) - should'nt user01 also inherit this? If not - what benefit exists in grouping users under a Role? Cheers! _________________________________________________________________ Spice up your IM conversations. New, colorful and animated emoticons. Get chatting! http://server1.msn.co.in/SP05/emoticons/
В списке pgsql-general по дате отправления: