Re: Protecting stored procedures

From: Michael Gould <mgould(at)intermodalsoftwaresolutions(dot)net>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: Protecting stored procedures
Date: 2011-04-07 14:31:20
Message-ID: cd29da798eeb202b87186ad3dcc9a2e2@intermodalsoftwaresolutions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We wouldn't make any of the system users a superuser in Postgres and in my
20+ years experience in the industry we provide software for, the
possibility of having any users of the system that are able to hack or even
understand what they have if they were able to is slim. I understand that
anything can be reverse engineered. I had a relationship with a Russian
program several years ago that could take the compile C modules, reverse
engineer them to assembler and then back to the original C code to find and
report bugs. That being said I don't worry too much about those types.

Best Regards

Michael Gould

"Andrew Sullivan" <ajs(at)crankycanuck(dot)ca> wrote:
> On Thu, Apr 07, 2011 at 07:46:36AM -0500, Michael Gould wrote:
>> We want to protect the intellectual property of several of our stored
>> procedures.  If we put them in a separate schema in the database and only
>> allow execute on anything in that schema would that protect our stored
>> procedures?
>
> If your customer can have superuser access on the machine (which
> effectively means, "If your customer has control of the box,") then
> no, it won't.
>
> If you need to do this sort of thing, then you need to write the
> procedures in C and deliver only object code. Even that probably
> won't solve everything.
>
> A
>
> --
> Andrew Sullivan
> ajs(at)crankycanuck(dot)ca
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-04-07 14:38:23 Re: database backup throws errors
Previous Message Vibhor Kumar 2011-04-07 14:09:05 Re: Attaching/detaching tablespaces (or, in general, parts of a DB)