Postgres Pro
Downloads
Home   >   mailing lists

revoke select right on pg_proc - Mailing list pgadmin-support

From Quan Zongliang
Subject revoke select right on pg_proc
Date
Msg-id 20100427213526.af12507c.quanzongliang@gmail.com
Whole thread Raw
Responses Re: revoke select right on pg_proc
List pgadmin-support
Tree view 
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>

pgadmin-support by date:

Previous
From: Barry Schatz
Date:
Subject: pgAgent and pgpass
Next
From: Quan Zongliang
Date:
Subject: Re: revoke select right on pg_proc