Re: 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