Thanks Ashesh, I ran below command and it is listing all privileges of objects under mydb schema. Actually, I want to know what are the permissions "user1" has on mydb schema. Could you please tell me how to do this?
mydb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where pc.relnamespace=pn.oid and pn.nspname='mydb'; relname | relacl ----------------------------------+----------------------------------------------- mylog | {postgres=arwdDxt/postgres,=arwdDxt/postgres} techtable | {postgres=arwdDxt/postgres,=ar/postgres} techtable_log | hrtable | {postgres=arwdDxt/postgres,=ar/postgres} hrtable_log | (5 rows) mydb=> select current_user; current_user -------------- user1 (1 row) mydb=> Thanks, Dipti On Thu, Mar 25, 2010 at 2:44 PM, Ashesh Vashi <ashesh.va...@enterprisedb.com > wrote: > 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 >> > >