Re: GRANT on information_schema & keys

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marcello Verona <marcelloverona(at)tiscali(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: GRANT on information_schema & keys
Date: 2007-09-11 19:44:32
Message-ID: 17751.1189539872@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Marcello Verona <marcelloverona(at)tiscali(dot)it> writes:
> I've a problem with the GRANT on information_schema and view
> "key_column_usage".
> Only a superuser is granted to see the record of this view (and other
> views about index... see table_constraint)
> What kind of permission is necessary for a simple user?

It will only show you rows about tables that you own or have some access
privilege for.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2007-09-11 20:04:14 pam authentication
Previous Message Tom Lane 2007-09-11 19:26:48 Re: Question about a query with two count fields