Thread: Protect PL/PGSQL source

Hello,

Does anyone knows if it´s possible to protect from users see a PL/PGSQL
source ?

I have a PL/PGSQL function and I want to make it invisible to users.

Just a example, in Oracle there is a option like this:
http://www.dbasupport.com/oracle/ora9i/wrap_utility.shtml

Regards,

Wilton Ruffato Wonrath
wrwonrath@yahoo.com.br
São Paulo - Brazil
PostgreSQL 8.2

On 2/14/07, Wilton <wilton.wonrath@microwork.inf.br> wrote:
> Hello,
>
> Does anyone knows if it´s possible to protect from users see a PL/PGSQL
> source ?
>
> I have a PL/PGSQL function and I want to make it invisible to users.

stored procedure code sits in the pg_proc table as you know.  access
to pg_proc is not required to run a function:

revoke select on pg_proc from public, foo;

be aware this breaks psql/pgadmin, etc for that user(s).

merlin