revoke select right on pg_proc

From: Quan Zongliang <quanzongliang(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: revoke select right on pg_proc
Date: 2010-04-27 13:35:26
Message-ID: 20100427213526.af12507c.quanzongliang@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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(at)gmail(dot)com>

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Quan Zongliang 2010-04-27 13:50:03 Re: revoke select right on pg_proc
Previous Message Barry Schatz 2010-04-26 16:56:21 pgAgent and pgpass