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.