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.