Re: Table / View Security Report

From: Bartosz Dmytrak <bdmytrak(at)gmail(dot)com>
To: "Schade, Jeffrey" <JSchade(at)iso(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table / View Security Report
Date: 2012-05-01 15:42:14
Message-ID: CAD8_UcbEh160GLSq1R=1BV+Z2z7-PaGFUeDm_67RqcOZMGbgWA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, take a look at pg_class table, column relacl
http://www.postgresql.org/docs/8.2/static/catalog-pg-class.html

The opposite way (does a user has privilages to...) is set of build in
functions
http://www.postgresql.org/docs/8.2/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE

hope this helps

Regards,
Bartek

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bartosz Dmytrak 2012-05-01 15:43:25 Re: Explain verbose query with CTE
Previous Message Adrian Klaver 2012-05-01 13:38:44 Re: Having trouble with pg_dumpall -o