From: | "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com> |
---|---|
To: | "Robert Bernabe" <rbernabe(at)sandmansystems(dot)com> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: WITH ENCRYPTION feature ? |
Date: | 2008-01-24 13:36:33 |
Message-ID: | 36e682920801240536n77a420aw15192223537bb5d7@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Jan 24, 2008 4:32 AM, Robert Bernabe <rbernabe(at)sandmansystems(dot)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(dot)harris(at)enterprisedb(dot)com
Edison, NJ 08837 | http://www.enterprisedb.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Didier Gasser-Morlay | 2008-01-24 14:50:12 | Order of triggers |
Previous Message | Sean Davis | 2008-01-24 11:39:34 | Re: WITH ENCRYPTION |