Skip site navigation (1) Skip section navigation (2)

Re: WITH ENCRYPTION feature ?

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 (view raw or flat)
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/

In response to

pgsql-novice by date

Next:From: Didier Gasser-MorlayDate: 2008-01-24 14:50:12
Subject: Order of triggers
Previous:From: Sean DavisDate: 2008-01-24 11:39:34
Subject: Re: WITH ENCRYPTION

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group