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<http://www.enterprisedb.com> On Thu, Mar 25, 2010 at 2:37 PM, dipti shah <shahdipti1...@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 >
