Skip site navigation (1) Skip section navigation (2)

Re: Object Privileges

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Marc Abbott <MarcA(at)Medscheme(dot)co(dot)za>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Object Privileges
Date: 2008-07-08 11:28:09
Message-ID: 98F71429-2DBE-4EAC-A2B8-DD75CEBF76F9@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-novice
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.





In response to

pgsql-novice by date

Next:From: Albe LaurenzDate: 2008-07-08 11:33:29
Subject: Re: please explain vacuum with WAL
Previous:From: Dmitry MelekhovDate: 2008-07-08 09:22:35
Subject: Re: please explain vacuum with WAL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group