Re: Getting users/privs for tables. - Mailing list pgsql-general

From Tom Lane
Subject Re: Getting users/privs for tables.
Date
Msg-id 12549.1300373911@sss.pgh.pa.us
Whole thread Raw
In response to Getting users/privs for tables.  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> I'm trying to determine who has what privs for what tables.  Couldn't find any canned views for that (but may have
missedit).  Or is there a query that can get this from the metadata somehow? 

You could try using has_table_privilege() in a join between pg_class and
pg_authid ... might be a bit slow though.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Is PostgreSQL supported on RHEL6?
Next
From: Adrian Klaver
Date:
Subject: Re: Getting users/privs for tables.