Postgres Pro
Downloads
Home   >   mailing lists

Re: Get the list of permissions/privileges on schema - Mailing list pgsql-general

From Ashesh Vashi
Subject Re: Get the list of permissions/privileges on schema
Date
Msg-id 8cf965d31003250214n6744b09cr60a6e8714eb0d81c@mail.gmail.com
Whole thread Raw
In response to Get the list of permissions/privileges on schema  (dipti shah <shahdipti1980@gmail.com>)
Responses 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>)
List pgsql-general
Tree view
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 by date:

Previous
From: dipti shah
Date:
Subject: Get the list of permissions/privileges on schema
Next
From: Sergey Konoplev
Date:
Subject: Re: Get the list of permissions/privileges on schema