Re: Users, groups and inheritance questions

Thanks Tom & ludwig, I understand now.

<b><a rel="nofollow">Glyn Astill</a>
</b>

----- Original Message ----
From: "ludwig(at)kni-online(dot)(dot)de" <ludwig(at)kni-online(dot)de>
To: pgsql-general(at)postgresql(dot)org
Sent: Friday, 28 March, 2008 3:24:34 PM
Subject: Re: [GENERAL] Users, groups and inheritance questions

Hello Glyn,
it's confusing, but You didn't read the manual very carefully!

Short excerpt:
The INHERIT attribute governs inheritance of grantable privileges (that is, access privileges for
database objects and role memberships). It does not apply to the special role attributes set by CREATE
ROLE and ALTER ROLE. For example, being a member of a role with CREATEDB privilege does not
immediately grant the ability to create databases, even if INHERIT is set; it would be necessary to
become that role via SET ROLE before creating a database.

bye...
Ludwig

__________________________________________________________
Sent from Yahoo! Mail.
A Smarter Inbox http://uk.docs.yahoo.com/nowyoucan.html