From: | <ludwig(at)kni-online(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Users, groups and inheritance questions |
Date: | 2008-03-28 15:24:34 |
Message-ID: | 31788337.321201206717874011.JavaMail.servlet@pustefix152.kundenserver.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
<p>Hello Glyn,</p><p>it's confusing, but You didn't read the manual very carefully!</p><p> </p><p>Short excerpt:</p><p>The INHERIT attribute governs inheritance of grantable privileges (that is, access privileges for<br />database objects and role memberships). It does not apply to the special role attributes set by CREATE<br />ROLE and ALTER ROLE. For example, being a member of a role with CREATEDB privilege does not<br />immediately grant the ability to create databases, even if INHERIT is set; it would be necessary to<br />become that role via SET ROLE before creating a database.</p><p> </p><p>bye...</p><p>Ludwig</p><p> </p><p> </p>
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/html | 673 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-general-owner | 2008-03-28 15:29:45 | [pgsql-general] Daily digest v1.8037 (17 messages) |
Previous Message | Dawid Kuroczko | 2008-03-28 15:24:32 | Re: Survey: renaming/removing script binaries (createdb, createuser...) |