Re: Getting users/privs for tables.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Getting users/privs for tables.
Date: 2011-03-17 14:58:31
Message-ID: 12549.1300373911@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)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 missed it). 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2011-03-17 14:59:29 Re: Getting users/privs for tables.
Previous Message Tom Lane 2011-03-17 14:52:36 Re: Is PostgreSQL supported on RHEL6?