Re: user privileges for particular table - Mailing list pgsql-general

From Tom Lane
Subject Re: user privileges for particular table
Date
Msg-id 17946.978557083@sss.pgh.pa.us
Whole thread Raw
In response to user privileges for particular table  ("Thomas T. Thai" <tom@minnesota.com>)
List pgsql-general
"Thomas T. Thai" <tom@minnesota.com> writes:
> how can you show a user's privileges for a particular table of a
> particular db?

The info is in the relacl column of pg_class's row for that table.  You
might also have to look at pg_group to determine whether the user is a
member of any groups that are granted privileges on the table.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] Numeric and money
Next
From: Shterke Seben
Date:
Subject: Problems about extracting data with cgi's