Securing stored procedures and triggers

From: mgould <mgould(at)allcoast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Securing stored procedures and triggers
Date: 2007-10-31 14:39:55
Message-ID: 20071031143955.83616a2d@mail.allcoast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2007-10-31 14:42:40 Re: Join between tables of two or more databases
Previous Message Anton Andreev 2007-10-31 14:34:44 day of week