Re: permissions from system catalogs - Mailing list pgsql-sql

From Tom Lane
Subject Re: permissions from system catalogs
Date
Msg-id 27703.1151371731@sss.pgh.pa.us
Whole thread Raw
In response to permissions from system catalogs  (Kyle Bateman <kyle@actarg.com>)
List pgsql-sql
Kyle Bateman <kyle@actarg.com> writes:
> Can anyone point me where to look in the system catalogs (or information 
> schema) to determine in advance whether a given user (or the current 
> user) will have select permission to a given table or view?

Try has_table_privilege()

http://www.postgresql.org/docs/8.1/static/functions-info.html
        regards, tom lane


pgsql-sql by date:

Previous
From: "Aaron Bono"
Date:
Subject: Re: avg(interval)
Next
From: Michael Fuhr
Date:
Subject: Re: permissions from system catalogs