Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

User specific data obfuscation

820206Jan 24 2013 — edited Jan 25 2013

Hi All,

I have the following requirement and we are on R12.1.3 with Oracle 11gR2 database on a Linux R5 machine.

1) Senstive data such as SSN and credit card needs to masked in the oracle seeded table like per_all_people_f etc.
2) This original data should not be visible either from the database (apps user) or via the application. They should both provide the decrypted data to the users.
3) There are a set of users that need point # 2 overidden. That is, they should be able to see the decrypted data usign sql on the tables or via the application (front end).

Have anyone stumbled upon a similar requirement in their implementations ever? Appreciate some examples or any pointers..

Thanks,
Rahul

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 22 2013

Added on Jan 24 2013

#database-security, #database-security-general

4 comments

556 views