On Fri, Jun 26, 2009 at 10:56:34AM +0200, luca.ciciriello@xxxxxxxx wrote: > I've wrote a PLPGSQL stored procedure for a DB I've to delivery to > my customer. The problem is that I want to hide the code of the > stored procedure. I don't want that my customer is able to read the > code of the my sp. > > Do exist a way to mask the code of the store procedure shipped with > my DB? Others have pointed out that there isn't really, along with a bit of a hack, which doesn't protect you from snooping into the procedure code if the client has (or can get) database super-user access. If you don't wish to expose this to clients, don't ship it to them. If you wish to restrict clients' use of what you do ship them, the appropriate place to do so is in the license and/or contract. Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
