Permission for relationship but not for select is possible?

Поиск
Список
Период
Сортировка
От Edson Richter
Тема Permission for relationship but not for select is possible?
Дата
Msg-id BLU0-SMTP251F376DEB008660F231F29CF3C0@phx.gbl
обсуждение исходный текст
Список pgsql-general
I would like to have two schemas:

MyDB.sales
MyDB.security

Users that have rights in sales schema should be able to
select/insert/update/delete. The same users must have rights to check
foreign keys against users table (but they are now allowed to execute
select on this table).
Is that possible? Can you help me to find relevant page in manuals for
9.1 or 9.2?

I wish to you all a Happy New Year!

Thanks,

Edson


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

Предыдущее
От: Philipp Kraus
Дата:
Сообщение: Re: rights for schema
Следующее
От: Philipp Kraus
Дата:
Сообщение: trigger on adding / deleting / modify user on pg_authid