Re: obfuscate an integer and store in a number column

From: Pedro Lopes <pedro.lopes_at_netvisao.pt>
Date: Fri, 11 Feb 2005 17:08:13 +0000
Message-ID: <newscache$oebrbi$s5b$1@newsfront4.netvisao.pt>

but the requirement is to have data encrypted ! not hidden away... like using mechanisms as views, vpds, label security.

This is a costumer requirement...
The application already hides the price from the user, but the requirement is to have the price encrypted also.

thanks
pedro

Sybrand Bakker wrote:
> On Thu, 10 Feb 2005 21:35:00 +0000, Pedro Lopes
> <pedro.lopes_at_netvisao.pt> wrote:
>
>

>>the security requirement is to have the price column which is a 
>>number(22) encrypted.

>
>
> I assume there are no Oracle accounts with proper passwords?
> If that has been setup properly, and the appropiate persons have
> access to a view only without the price, you wouldn't have to live
> with such ill-advised security paranaoia requirements.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Fri Feb 11 2005 - 11:08:13 CST