"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
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: