This email is subject to a disclaimer which may be found on our website by clicking on this link: disclaimer. If you would prefer, the disclaimer can be emailed to you by clicking here.
Hi
I was wondering if there are similar views in postgres to those in Oracle (DBA_TAB_PRIVS, DBA_ROLE_PRIVS etc.) where one can obtain current privileges granted to objects on the database. I have come across the \dp and \z commands but I want to write dynamic sql to generate scripts for granting and revoking. Any help would be appreciated.
Regards
Marc