ROLE INHERIT

Поиск
Список
Период
Сортировка
Искать
От
David Legault
Тема
ROLE INHERIT
Дата
Msg-id
e0b20d410702151535yd3e6ac6xb898bfbdbc11c572@mail.gmail.com
Список
Дерево обсуждения
ROLE INHERIT "David Legault" <legault.david@gmail.com>
Re: ROLE INHERIT Alvaro Herrera <alvherre@commandprompt.com>
Re: ROLE INHERIT "David Legault" <legault.david@gmail.com>
Re: ROLE INHERIT Tom Lane <tgl@sss.pgh.pa.us>
Re: ROLE INHERIT Kenneth Downs <ken@secdat.com>
Re: ROLE INHERIT Tom Lane <tgl@sss.pgh.pa.us>
Re: ROLE INHERIT Kenneth Downs <ken@secdat.com>
Re: ROLE INHERIT Stephen Frost <sfrost@snowman.net>
Re: ROLE INHERIT "David Legault" <legault.david@gmail.com>
Re: ROLE INHERIT Paul Lambert <paul.lambert@autoledgers.com.au>
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

В списке pgsql-general по дате отправления
От: Devrim GUNDUZ
Дата:
От: Paul Lambert
Дата:
Сообщение: Re: ROLE INHERIT
FAQ