ROLE INHERIT

From: "David Legault" <legault(dot)david(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ROLE INHERIT
Date: 2007-02-15 23:35:27
Message-ID: e0b20d410702151535yd3e6ac6xb898bfbdbc11c572@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I'm a bit new to Postgre, and I'm experimenting with the roles stuff.

I want to know why If I create a role called "administrator" (a group
basically, no login) :

CREATE ROLE administrator NOSUPERUSER INHERIT NOCREATEDB CREATEROLE;

And then create a user

CREATE ROLE admin LOGIN PASSWORD 'password' ON ROLE administrator;

admin doesn't have the CREATEROLE privilege himself, but because he is part
of a group that has it, why doesn't this fall back on him having it?

When I try to use that admin user to create another role, it says
insufficient privileges.

Am I missing something in this role stuff ?

Thanks

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Lambert 2007-02-15 23:53:19 Re: ROLE INHERIT
Previous Message Alvaro Herrera 2007-02-15 23:24:09 Re: postgresql 8.2 Installation error at "gmake"