Re: [GENERAL] Table / View Security Report

2012-05-01 Thread Bartosz Dmytrak
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 h

[GENERAL] Table / View Security Report

2012-05-01 Thread Schade, Jeffrey
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 w