Re: Permissions Query? - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Permissions Query?
Date
Msg-id 20070119191545.GB29447@phlogiston.dyndns.org
Whole thread Raw
In response to Permissions Query?  (paallen@attglobal.net)
List pgsql-sql
On Fri, Jan 19, 2007 at 07:11:00PM +0000, paallen@attglobal.net wrote:
> I now want to know if the user/role has permision
> to the schema.table.
> 
> How do I query to pgsql to know what permissions a
> particular user has on the table?

Start here:

http://www.postgresql.org/docs/8.1/interactive/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE

A
-- 
Andrew Sullivan  | ajs@crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?    --attr. John Maynard Keynes


pgsql-sql by date:

Previous
From: paallen@attglobal.net
Date:
Subject: Permissions Query?
Next
From: mawrya
Date:
Subject: select based on multi-column primary keys