Search Postgresql Archives

Re: Protect PL/PGSQL source

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 2/14/07, Wilton <wilton.wonrath@xxxxxxxxxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux