Re: viewing source code - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: viewing source code
Date
Msg-id 20071218182649.GB8088@alvh.no-ip.org
Whole thread Raw
In response to Re: viewing source code  ("Roberts, Jon" <Jon.Roberts@asurion.com>)
List pgsql-performance
Roberts, Jon escribió:

> Revoking pg_proc isn't good for users that shouldn't see other's code but
> still need to be able to see their own code.

So create a view on top of pg_proc restricted by current role, and grant
select on that to users.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

Previous
From: "Roberts, Jon"
Date:
Subject: Re: viewing source code
Next
From: "Roberts, Jon"
Date:
Subject: Re: viewing source code