For FDM masking does the actual masking executable need read access to Oracle System tables and views to mask the data?
search cancel

For FDM masking does the actual masking executable need read access to Oracle System tables and views to mask the data?

book

Article ID: 204395

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

The DBA has granted me read/write/select on tables that need to be masked. We developed the masking in the lower environment. In the actual masking environment what roles/privileges does FDM need to read system catalog tables or views?

Environment

Release : 4.9

Component : CA Test Data Manager - Fast Data Masker

Cause

N/A

Resolution

As per development:

Their DBA should be able to tell him what is needed.

a quick google tells me
SELECT ANY DICTIONARY

But found this as well:

https://docs.oracle.com/database/121/TTSYS/systemtables.htm#TTSYS348

I don't think it is an FDM, but more tied to the database itself.