Re: masking the code - Mailing list pgsql-general

From David Fetter
Subject Re: masking the code
Date
Msg-id 20090626163508.GD21081@fetter.org
Whole thread Raw
In response to masking the code  (luca.ciciriello@email.it)
List pgsql-general
On Fri, Jun 26, 2009 at 10:56:34AM +0200, luca.ciciriello@email.it 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@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: Need suggestions
Next
From: "Bob Pawley"
Date:
Subject: Need help using function