Postgres Pro
Downloads
Home   >   mailing lists

Re: Check if SELECT is granted - Mailing list pgsql-general

From Tom Lane
Subject Re: Check if SELECT is granted
Date
Msg-id 5972.1125605547@sss.pgh.pa.us
Whole thread Raw
In response to Check if SELECT is granted  (Poul Møller Hansen <freebsd@pbnet.dk>)
Responses Re: Check if SELECT is granted
List pgsql-general
Tree view 
=?UTF-8?B?UG91bCBNw7hsbGVyIEhhbnNlbg==?= <freebsd@pbnet.dk> writes:
> I'm wondering if it's possible for the ordinary user to check if SELECT
> is granted on a give table, without doing the select ?

See the has_table_privilege() function.

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: ODBC and inappropriate select *
Next
From: Steve Crawford
Date:
Subject: Re: ODBC and inappropriate select *