Re: deny access to system tables - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: deny access to system tables
Date
Msg-id 20021010124336.GB23840@wolff.to
Whole thread Raw
In response to Re: deny access to system tables  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
On Thu, Oct 10, 2002 at 08:42:32 -0400,
>
> If I could prevent access to pg_proc the user would (theoretically) not be
> able to run any functions, and more importantly would not be able to see the
> source of my functions.  I believe the same hold true for pg_views.

You might want to consider upgrading to 7.3 (currently in beta). In 7.3
you can control the ability to execute specific functions using grant
and revoke.

pgsql-general by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: Getting tables, procedures, etc.
Next
From: Martijn van Oosterhout
Date:
Subject: Re: deny access to system tables