Results 1 to 2 of 2
  1. #1
    Join Date
    May 2010
    Posts
    1

    Unanswered: Encrypt Postgres functions to hide business logic

    Hi everyone,

    how to encrypt functions in Postgresql so i can hide all my business logic ?

    is there any option like with encryption prent in MS SQL ?


    Regards,

    Yogesh.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by yogeshp2810 View Post
    is there any option like with encryption prent in MS SQL
    No.


    The TODO page in the Postgres Wiki suggests one "workaround":
    Quote Originally Posted by Postgres Wiki
    Obfuscated function source code (not wanted)

    Obfuscating function source code has minimal protective benefits because anyone with super-user access can find a way to view the code. At the same time, it would greatly complicate backups and other administrative tasks. To prevent non-super-users from viewing function source code, remove SELECT permission on pg_proc.
    Taken from:
    http://wiki.postgresql.org/wiki/Todo

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •