Re: [postgresql 9.2.3] schema and privileges

Поиск
Список
Период
Сортировка
От Prashanth Goriparthi
Тема Re: [postgresql 9.2.3] schema and privileges
Дата
Msg-id CA+Mf8bXZuqAbNoSnHPZkAjyOmxHAM+rfjr_HMn8Q3sOfPDa-SQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [postgresql 9.2.3] schema and privileges  (Christian Hammers <ch@lathspell.de>)
Список pgsql-novice
Дерево обсуждения
Like Christian Hammers already mentioned, you need to grant access to each and every object in that schema to user1 for having access to it.

Here is an example of how those grants look like:

GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE table_x TO user1;

GRANT SELECT, UPDATE ON TABLE table_x_table_x_id_seq TO user1;

Same this applies for all functions/views etc etc., I hope this is clear to you.

Thanking you,
Prashanth Kumar Goriparthi


On Thu, Mar 14, 2013 at 2:08 PM, Christian Hammers <ch@lathspell.de> wrote:
Read the last sentence again ,-) You gave  rights to only the Schema not everything below it.

bye,
-christian-
--
Sent via pgsql-novice mailing list (pgsql-novice@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

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

Предыдущее
От: Christian Hammers
Дата:
Сообщение: Re: [postgresql 9.2.3] schema and privileges
Следующее
От: Marcel Ruff
Дата:
Сообщение: org.postgresql.util.PSQLException: ERROR: invalid page header in block 5869177 of relation base/17291/17420