Re: deny access to system tables

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: deny access to system tables
Date: 2002-10-10 12:43:36
Message-ID: 20021010124336.GB23840@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Savita 2002-10-10 12:57:43 Re: Problem running postgre as a windows NT service
Previous Message Robert Treat 2002-10-10 12:42:32 Re: deny access to system tables