"Greg Sabino Mullane" <greg(at)turnstep(dot)com> writes:
>>> SELECT *,has_schema_privilege(oid,'USAGE') FROM pg_namespace;
>> Well, if you test it as a superuser, it's going to return TRUE every
> Exactly. So I'm not seeing how we can use USAGE as a reliable test for
> the case where a temporary table was created by the same user, but in
> another session.
Superusers can access anything they want to. What's your point?
The spec says "accessible" ...
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2006-09-05 00:02:52|
|Subject: Stressful time|
|Previous:||From: Gavin Sherry||Date: 2006-09-04 23:57:29|
|Subject: Re: [PATCHES] Trivial patch to double vacuum speed|
pgsql-committers by date
|Next:||From: Bruce Momjian||Date: 2006-09-05 00:13:41|
|Subject: pgsql: Update Japanese FAQ.|
|Previous:||From: Greg Sabino Mullane||Date: 2006-09-04 23:49:58|
|Subject: Re: [COMMITTERS] pgsql: Sequences were not being shown due to the use of lowercase `s`|