From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | <fasupport(at)allcoast(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Securing stored procedures and triggers |
Date: | 2007-10-31 15:55:34 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C27F71F7@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
mgould wrote:
> We are currently migrating from Sybase's ASA 9/10 to PostGres
> 8.2.4. One of the features that is really nice in ASA is the
> ability to add the attribute hidden to a Create procedure,
> Create function and Create trigger. Essentially what this
> does is encrypt the code so that if anyone or any utility
> gets into the database they cannot see any of the actual
> code. This is a great feature for protecting intellectual
> processing techniques. I don't know if there is anyway to do
> this in PostGres. Before the hidden feature was added, we
> had a competitor steal some of our stored procedure
> processing code. Is there anyway to protect this from
> happening in PostGres?
Not with PL/pgSQL.
That's probably not what you want, but you can write
stored procedures in C and ship the shared library.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2007-10-31 15:58:32 | Re: Join between tables of two or more databases |
Previous Message | Pavel Stehule | 2007-10-31 15:35:56 | Re: Join between tables of two or more databases |