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@gmail.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@gmail.com>
--
Quan Zongliang <quanzongliang@gmail.com>