Re: Privileges on public schema can't be revoked?

Stephen Frost <sfrost(at)snowman(dot)net> writes:
> \dn+ in psql will give you the access privileges for all schemas.

> I'd have to look at the "other solutions" you're referring to, but, in
> general, we do not exclude the public role in any way from the access
> privilege system.

Possibly Greg was thinking of the information_schema views. Grants to
PUBLIC do show up in those. The problem is that there's no view there
that covers schema privileges, probably because the SQL standard doesn't
really have any such thing as grantable schema privileges. (Or at least
it didn't last I heard, I might be out of date.)

regards, tom lane