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 <[email protected]> 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 <[email protected]> -- Quan Zongliang <[email protected]> -- Sent via pgadmin-support mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
