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
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" |