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: AE9526F06FFC114E9087A83BC2A648BBDF1BF8@ZARDPEXCH001.medscheme.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


This email is subject to a disclaimer which may be found by connecting to www.medscheme.co.za 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".

---------------------------------------------------------------------------------------------------------------------------------
Hi

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.

Regards

Marc

Responses

Browse pgsql-novice by date

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