Database Security Products (MOSC)

MOSC Banner

Consistent masking of denormalized columns?

edited Aug 2, 2016 6:22PM in Database Security Products (MOSC) 2 commentsAnswered ✓

In an oversimplified example, I have a table PERSON, which has an PERSON_ID, FIRST_NAME and LAST_NAME columns.   I have another table, populated by business logic that contains a number of columns, which include FIRST_NAME and LAST_NAME, but not PERSON_ID of course.

What technique should be used with data masking to ensure that the masked FIRST_NAME and LAST_NAME columns in each table are consistent?   I don't want to mask Doug to Bob in one table and Doug to Fred in another.

TIA,

Doug

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center