[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] Permissions Query?
From:       Andrew Sullivan <ajs () crankycanuck ! ca>
Date:       2007-01-19 19:15:45
Message-ID: 20070119191545.GB29447 () phlogiston ! dyndns ! org
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
[prev in list] [next in list] [prev in thread] [next in thread]