Re: [GENERAL] Role & User - Inheritance?

2007-03-15 Thread Tom Lane
"Alexi Gen" <[EMAIL PROTECTED]> writes: > Since user01 is tagged to dba01 (who has the SUPERUSER option) - should'nt > user01 also inherit this? No, he has to actually SET ROLE to the superuser account to make himself a superuser. SUPERUSER and the other non-GRANTable attributes of a role don't

Re: [GENERAL] Role & User - Inheritance

2007-03-15 Thread David Legault
wrote: [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 cr

[GENERAL] Role & User - Inheritance?

2007-03-15 Thread Alexi Gen
[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 t