Re: GRANT on information_schema & keys - Mailing list pgsql-general

From Tom Lane
Subject Re: GRANT on information_schema & keys
Date
Msg-id 17751.1189539872@sss.pgh.pa.us
Whole thread Raw
In response to GRANT on information_schema & keys  (Marcello Verona <marcelloverona@tiscali.it>)
List pgsql-general
Marcello Verona <marcelloverona@tiscali.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question about a query with two count fields
Next
From: Sean Davis
Date:
Subject: pam authentication