Skip site navigation (1) Skip section navigation (2)

Re: Users, groups and inheritance questions

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: ludwig(at)kni-online(dot)de, pgsql-general(at)postgresql(dot)org
Subject: Re: Users, groups and inheritance questions
Date: 2008-03-28 16:03:47
Message-ID: 635239.53406.qm@web25811.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
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

pgsql-general by date

Next:From: Tomasz OstrowskiDate: 2008-03-28 16:19:42
Subject: Re: Delete after trigger fixing the key of row numbers
Previous:From: Richard BroersmaDate: 2008-03-28 16:02:45
Subject: Re: table of US states' neighbours

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group