Re: GRANT question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Együd Csaba <csegyud(at)vnet(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org, "'Michael Fuhr'" <mike(at)fuhr(dot)org>
Subject: Re: GRANT question
Date: 2005-11-27 06:54:36
Message-ID: 29356.1133074476@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud(at)vnet(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Együd Csaba (Freemail) 2005-11-27 07:02:37 Re: FW: GRANT question
Previous Message Együd Csaba 2005-11-27 06:51:49 Re: GRANT question