Re: permissions from system catalogs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kyle Bateman <kyle(at)actarg(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: permissions from system catalogs
Date: 2006-06-27 01:28:51
Message-ID: 27703.1151371731@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Kyle Bateman <kyle(at)actarg(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fuhr 2006-06-27 01:36:22 Re: permissions from system catalogs
Previous Message Aaron Bono 2006-06-27 00:53:09 Re: avg(interval)