PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Query Masking - Does it work?

Hello,

Has anyone tried query masking and made it work?

For my testing,

  1. I have EX_EE_PYMNT_DTL.BANK_ACCOUNT_NUM is set as a PI and Sensitive Information.
  2. Query Masking is enabled
  3. Set one role as Authorized for EX_EE_PYMNT_DTL.BANK_ACCOUNT_NUM
  4. Ran Query Data Masking Sync
  5. Created query on EX_EE_PYMNT_DTL where BANK_ACCOUNT_NUM <> ' '
  6. Query result shows BANK_ACCOUNT_NUM not masked
  7. Set role from #3 as Unauthorized for EX_EE_PYMNT_DTL.BANK_ACCOUNT_NUM
  8. Ran Query Data Masking Sync
  9. Ran same query as in #5
  10. Query result shows BANK_ACCOUNT_NUM not masked

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