Thread: Hide function body from users

Hide function body from users

From
"Alexander S. Evdokimov"
Date:
Hello pgsql-admin,

  Ppl, Hi!
  I recently find, that \df+ my_function  in psql, shows the whole
  source code of function to user with any access rights.. this is
  very harmful :( .
  Does any body know are there any possibility to hide function
  description (i.e. source code of plpgsql function) from users?

--
Best regards,
 Alexander S. Evdokimov                          mailto:alexan@nautsilus.ru


Re: Hide function body from users

From
Tom Lane
Date:
"Alexander S. Evdokimov" <alexan@nautsilus.ru> writes:
>   Does any body know are there any possibility to hide function
>   description (i.e. source code of plpgsql function) from users?

No.

You could perhaps convert the function into C if you want to obfuscate
it.

            regards, tom lane