Table / View Security Report

Started by Schade, Jeffreyalmost 14 years ago2 messagesgeneral
Jump to latest
#1Schade, Jeffrey
JSchade@iso.com

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@iso.com <mailto:jschade@iso.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.

#2Bartosz Dmytrak
bdmytrak@gmail.com
In reply to: Schade, Jeffrey (#1)
Re: Table / View Security Report

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