Stephen Frost <sfrost@snowman.net> writes:
> Eh, it does and it doesn't. The SQL standard says that no roles are
> automatically inheirited and that you have to 'set role' to them. Thus,
> all non-user roles which are granted to users in Postgres would need to
> be defined 'noinherit' to have things work as the spec wants.
We note in the CREATE ROLE docs:
The behavior specified by the SQL standard is most closely approximatedby giving users the NOINHERIT attribute, while
rolesare given theINHERIT attribute.
For the purposes of the information_schema, it might work best to
consider NOINHERIT (rather than LOGIN) as being what identifies a user
rather than a role.
regards, tom lane