Re: Object Privileges

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.





-- 
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice