Thanks Tom & ludwig, I understand now.
<b><a rel="nofollow">Glyn Astill</a>
----- Original Message ----
From: "ludwig(at)kni-online(dot)(dot)de" <ludwig(at)kni-online(dot)de>
Sent: Friday, 28 March, 2008 3:24:34 PM
Subject: Re: [GENERAL] Users, groups and inheritance questions
it's confusing, but You didn't read the manual very carefully!
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.
Sent from Yahoo! Mail.
A Smarter Inbox http://uk.docs.yahoo.com/nowyoucan.html
pgsql-general by date
|Next:||From: Tomasz Ostrowski||Date: 2008-03-28 16:19:42|
|Subject: Re: Delete after trigger fixing the key of row numbers|
|Previous:||From: Richard Broersma||Date: 2008-03-28 16:02:45|
|Subject: Re: table of US states' neighbours|