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