On Jan 24, 2008 4:32 AM, Robert Bernabe <rbernabe@sandmansystems.com> wrote:
> Hi,
> Is there a translation of this MSSQL feature in PostgreSQL? It's
> still actually possible to decrypt the encrypted stored procedure in the
> server but end of the day it should be recognized that all these efforts
> will just serve to make things slightly more difficult (e.g. leaving
> your car unlocked instead of locked or leaving the keys inside). Anyways
> the feature in MSSQL will encrypt the stored procedure in the server
> such that when it's viewed by a sysad or anybody else, they will
> encrypted text instead of T-SQL code. Many Thanks in advance for any
> clues.
Nope, there is no such way to do this in Postgres. You can look
through the archives (primarily on -hackers) regarding encryption,
wrapping, and obfuscation.
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/