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  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 


-- 
Quan Zongliang