Re: Securing stored procedures and triggers

Il Wednesday 31 October 2007 15:39:55 mgould ha scritto:
> 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?
>
> Best Regards,
>
> Michael Gould
> All Coast Intermodal Services, Inc.
> 904-376-7030

I'm not sure about that feature being supported by PGSQL.
Don't think so, anyway.

But if your competitor needs to steal your code in order to compete,
then you are ahead of him: you think, he copies.

--
Reg me Please