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

Object Privileges

From: "Marc Abbott" <MarcA(at)Medscheme(dot)co(dot)za>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Object Privileges
Date: 2008-07-08 04:11:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
This email is subject to a disclaimer which may be found by connecting to and clicking on the "Terms of Use" link.
Alternatively, the disclaimer can be emailed to you by sending a blank email to "meds_disclaimer(at)medscheme(dot)co(dot)za".



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.





pgsql-novice by date

Next:From: Dmitry MelekhovDate: 2008-07-08 08:09:06
Subject: please explain vacuum with WAL
Previous:From: Tom LaneDate: 2008-07-07 14:07:59
Subject: Re: how to get dependancies of a table?

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