Question about schema-level permissions

Поиск
Список
Период
Сортировка
От Mike Christensen
Тема Question about schema-level permissions
Дата
Msg-id CABs1bs131m73_-4d13JszRmskpkTcf1pW9vjKBKSQ_mqq-tTPA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question about schema-level permissions  (Christophe Pettus <xof@thebuild.com>)
Список pgsql-general
I've created a schema called Indexer and a user called Indexer.  I
then grant Indexer ALL on said schema:

GRANT ALL ON SCHEMA Indexer TO "Indexer";

Next, I attempt to INSERT into Indexer.ParseErrors, I get a permission
denied error message.  However, if I specifically grant Indexer INSERT
permissions:

GRANT INSERT ON Indexer.ParseErrors TO "Indexer";

Then everything works.

Am I missing something?  Doesn't GRANT ALL mean that user can do
anything they want with objects in that schema, including inserts?
Thanks!

Mike

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Custom Domain; migration from 8.4 to 9.1 and COLLATE
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Question about schema-level permissions