Home » SQL & PL/SQL » SQL & PL/SQL » Masking in Oracle
Masking in Oracle [message #571565] Tue, 27 November 2012 02:30 Go to next message
sandeep_jain05
Messages: 1
Registered: November 2012
Location: Bangalore,India
Junior Member
Hi Everyone,

How we can mask a column value present in the production which is very sesitive like bank a/c no,Credit card nos etc while replicating to the test/development envirnoments in PL/SQL.Things that need to be considered is referential integrity,data types,length of the column and performace while execuing the code.Any help or pointer will be very helpful.Thanks !

Regards,
Sandeep
Re: Masking in Oracle [message #571569 is a reply to message #571565] Tue, 27 November 2012 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, search for Data Masking, it is an Oracle product/option but if you read the documentation about it you can see how to do it without having to pay the option (just like you can do a standby database without Data Guard).

Regards
Michel
Re: Masking in Oracle [message #571574 is a reply to message #571569] Tue, 27 November 2012 04:10 Go to previous message
Michel Cadot
Messages: 58607
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=57402&SkipA=0

Regards
Michel
Previous Topic: Dynamic Column Generation by using pivot
Next Topic: complex hours breakdown query
Goto Forum:
  


Current Time: Tue Jul 29 04:06:25 CDT 2014

Total time taken to generate the page: 0.23852 seconds