Re: Users, groups and inheritance questions - Mailing list pgsql-general

From
Subject Re: Users, groups and inheritance questions
Date
Msg-id 31788337.321201206717874011.JavaMail.servlet@pustefix152.kundenserver.de
Whole thread Raw
In response to Users, groups and inheritance questions  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-general
Hello Glyn,it's confusing, but You didn't read the manual very carefully! Short excerpt:The INHERIT
attributegoverns inheritance of grantable privileges (that is, access privileges fordatabase objects and role
memberships).It does not apply to the special role attributes set by CREATEROLE and ALTER ROLE. For example, being a
memberof a role with CREATEDB privilege does notimmediately grant the ability to create databases, even if INHERIT is
set;it would be necessary tobecome that role via SET ROLE before creating a database. bye...Ludwig   

pgsql-general by date:

Previous
From: Felipe de Jesús Molina Bravo
Date:
Subject: Re: Persistent user-defined functions
Next
From: "Scott Marlowe"
Date:
Subject: Re: Using tables in other PostGreSQL database