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.
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 |