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.vashi@xxxxxxxxxxxxxxxx> 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 CompanyOn Thu, Mar 25, 2010 at 2:37 PM, dipti shah <shahdipti1980@xxxxxxxxx> 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