Thread: Object Privileges
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
On Jul 8, 2008, at 12:11 AM, Marc Abbott wrote: > 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. > You might find this to be a helpful starting point: http://pgedit.com/tip/postgresql/access_control_functions You might also check out the information schema. You can see the SQL used for any of the psql commands by starting psql with the -E option. John DeSoi, Ph.D.