Re: [GENERAL] Securing stored procedures and triggers

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly