Table / View Security Report

From: "Schade, Jeffrey" <JSchade(at)iso(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Table / View Security Report
Date: 2012-05-01 12:58:38
Message-ID: DB138660B6B01D458B16F9205C0C2634233E0D33@ISOEMAILP3.iso.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We recently installed the GreenPlum massively Parallel Appliance which
is using Postgres version 8.2.15 and I have been asked to provide a
security report showing all user and group roles and the access they
have to the user data and views. In the Postgres catalog tables I have
located the tables which provide the security role information but I am
unable to locate any specific information showing the table and view
access (i.e. SELECT / INSERT / UPDATE / DELETE). Can someone tell me
where this information is stored or would anyone be able to share
security reports they may have written.

All help would be greatly appreciated.

Jeff

_________________________________________
Jeffrey Schade

Systems Consultant, Technology Engineering

ISO
545 Washington Boulevard
Jersey City, NJ 07310
Voice: (201) 469-3738

FAX: (201) 748-1500
jschade(at)iso(dot)com <mailto:jschade(at)iso(dot)com>

This email is intended for the recipient only. If you are not the intended recipient please disregard, and do not use the information for any purpose.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-05-01 13:35:18 Re: Having trouble with pg_dumpall -o
Previous Message Mark Morgan Lloyd 2012-05-01 12:51:43 Re: Listen and Notify