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: (view raw, whole thread or download thread mbox)
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:

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-2017 The PostgreSQL Global Development Group