We have a development database with sensitive data on it that we would like to mask. I've done so with a translate statement, but the problem is, the key is in the script, so anyone with access to the script could decipher the masked data. We have a similar process in SQL server that randomly replaces one ascii value for another to scramble the data, but I haven't been able to do that in Oracle. Does anyone have any suggestions? If I could figure out how to randomly create a key, then I could refer to it in the translate step.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Scrambling Data
- Thread starter SLamb88
- Start date
SantaMufasa
Technical User
SLamb88,
You can hide your translation algorithm from external views by embedding the algorithm in a PL/SQL procedure which you then place inside a "wrapper" that itself is encoded such that the code is no longer human readable.
You can Google a metric-ton of information about how to place your code in a wrapper if you use "PL/SQL wrapper" as your Google search term.
![[santa]](/data/assets/smilies/santa.gif "[santa] [santa]")
Mufasa
(aka Dave of Sandy, Utah, USA @ 18:05 (01Sep04) UTC (aka "GMT" and "Zulu"), 11:05 (01Sep04) Mountain Time)
You can hide your translation algorithm from external views by embedding the algorithm in a PL/SQL procedure which you then place inside a "wrapper" that itself is encoded such that the code is no longer human readable.
You can Google a metric-ton of information about how to place your code in a wrapper if you use "PL/SQL wrapper" as your Google search term.
Mufasa(aka Dave of Sandy, Utah, USA @ 18:05 (01Sep04) UTC (aka "GMT" and "Zulu"), 11:05 (01Sep04) Mountain Time)
- Status
Similar threads
- Locked
- Question