On 2/14/07, Wilton <wilton(dot)wonrath(at)microwork(dot)inf(dot)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