Query Masking - Does it work?
Hello,
Has anyone tried query masking and made it work?
For my testing,
- I have EX_EE_PYMNT_DTL.BANK_ACCOUNT_NUM is set as a PI and Sensitive Information.
- Query Masking is enabled
- Set one role as Authorized for EX_EE_PYMNT_DTL.BANK_ACCOUNT_NUM
- Ran Query Data Masking Sync
- Created query on EX_EE_PYMNT_DTL where BANK_ACCOUNT_NUM <> ' '
- Query result shows BANK_ACCOUNT_NUM not masked
- Set role from #3 as Unauthorized for EX_EE_PYMNT_DTL.BANK_ACCOUNT_NUM
- Ran Query Data Masking Sync
- Ran same query as in #5
- Query result shows BANK_ACCOUNT_NUM not masked
0