On Mon, Sep 10, 2007 at 11:17:21AM -0400, Tom Lane wrote:
> > ok, but i belive it should either dont allow admin to do so, or, if it
> > does allow, it should behave more consistently.
> There are few "training wheels" for superuser mode. Try something like
> "delete from pg_proc" if you are looki
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> On Mon, Sep 10, 2007 at 10:38:34AM -0400, Tom Lane wrote:
>> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
>>> # revoke usage on schema pg_catalog from public;
>>> REVOKE
>> This is not a supported operation.
> ok, but i belive it sho
On Mon, Sep 10, 2007 at 10:38:34AM -0400, Tom Lane wrote:
> hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> > # revoke usage on schema pg_catalog from public;
> > REVOKE
> This is not a supported operation.
ok, but i belive it should either dont allow admin to do so, or, if it
does allow,
hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:
> # revoke usage on schema pg_catalog from public;
> REVOKE
This is not a supported operation.
regards, tom lane
---(end of broadcast)---
TIP 1: if posting/reading throug
user depesz is superuser. i connect to depesz database, and:
([EMAIL PROTECTED]:5830) 14:20:34 [depesz]
# revoke usage on schema pg_catalog from public;
REVOKE
now, i reconnect to the same database with test user (which is not
superuser):
([EMAIL PROTECTED]:5830) 14:23:55 [depesz]
> \d
ERROR: p
