Re: Get the list of permissions/privileges on schema

Поиск
Список
Период
Сортировка
От Ashesh Vashi
Тема Re: Get the list of permissions/privileges on schema
Дата
Msg-id 8cf965d31003250214n6744b09cr60a6e8714eb0d81c@mail.gmail.com
обсуждение исходный текст
Ответ на Get the list of permissions/privileges on schema  (dipti shah <shahdipti1980@gmail.com>)
Ответы Re: Get the list of permissions/privileges on schema  (Sergey Konoplev <gray.ru@gmail.com>)
Re: Get the list of permissions/privileges on schema  (dipti shah <shahdipti1980@gmail.com>)
Список pgsql-general
Дерево обсуждения
You should look into the pg_class table : relacl attribute for the permissions on any object.

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company


On Thu, Mar 25, 2010 at 2:37 PM, dipti shah <shahdipti1980@gmail.com> wrote:
Hi,
 
Could any one please tell me how to get list of all the permissions on the schema (or any postgresql objects), stored them somewhere before executing stored procedure and then restore them?
 
Thanks,
Dipti

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

Предыдущее
От: dipti shah
Дата:
Сообщение: Get the list of permissions/privileges on schema
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Get the list of permissions/privileges on schema