Re: revoke select right on pg_proc

in fact, that guy should not list anything in pgAdmin?
he said he can list views. it is weird.

in my test, i can select data in psql from tables that select right
has been granted. but I can't list and object in pgAdmin.

On Tue, 27 Apr 2010 21:35:26 +0800
Quan Zongliang <quanzongliang(at)gmail(dot)com> wrote:

> Hi, all
>
> someone said, his project needs to revoke select right from pg_proc:
> REVOKE SELECT ON pg_catalog.pg_proc FROM PUBLIC;
>
> Then pgAdmin can't list any table nodes and report a permission error.
> Because pgTableFactory::CreateObjects references to pg_proc, but
> can not access it.
>
> This is a abnormal case or a bug?
>
> --
> Quan Zongliang <quanzongliang(at)gmail(dot)com>

--
Quan Zongliang <quanzongliang(at)gmail(dot)com>