tde and fga

From: Steiner, Randy <Randy.Steiner_at_nyct.com>
Date: Wed, 12 Sep 2007 10:08:03 -0400
Message-ID: <D5006AF7251D5046A0A63E39A23148DC012164A2@NYCTEXVS07.transit.nyct.com>

Please tell me if this seems ok with everyone.

I am using tde. To do nightly datapumps, I need to put ENCRYPTION_PASSWORD = in the par file.

I now set up fga on that table and when I query dba_fga_audit_trail the sql_text field contains

"CARD_NO" ENCRYPT USING 'AES128' IDENTIFIED BY ENCRYPTION_PASSWORD Auditors will now be able to see the export encryption password.

Randy

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 12 2007 - 09:08:03 CDT