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
Unfortunately, Everything that is a permission (CREATEROLE, etc) when creating a role cannot be inherited. Only the GRANT stuff is inherited and I think only when the WITH .. is given on the GRANT. I may be wrong on the last part though. David On 3/15/07, Alexi Gen <[EMAIL PROTECTED]> wrote: