Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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>


pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group