Re: GRANT question - Mailing list pgsql-general

From Tom Lane
Subject Re: GRANT question
Date
Msg-id 29356.1133074476@sss.pgh.pa.us
Whole thread Raw
In response to Re: GRANT question  (Együd Csaba <csegyud@vnet.hu>)
List pgsql-general
=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@vnet.hu> writes:
>> ... it might also be interesting to try
>>     select current_schemas(true);

> in case of the admin it results: {pg_catalog,public}. In case of the
> non-admin user: {pg_catalog}!!!

I think that confirms Michael's suggestion that you've removed public
USAGE access on the public schema.  Not a very good move if you want
to share objects across users.

            regards, tom lane

pgsql-general by date:

Previous
From: Együd Csaba
Date:
Subject: Re: GRANT question
Next
From: Együd Csaba (Freemail)
Date:
Subject: Re: FW: GRANT question