Information on Auditing sensitive data
We have a process in place to mask and audit sensitive information in datawarehouse.
However we need some help in auditing in yellowfin repo DB.Note that we have data security in place for user level, this is for auditing developers.
For example, HR sensitive data can be accessed by a BI developer in yellowfin using the data source by creating a SQL based report. We want to audit the username and related info whenever developer tries to fetch sensitive data.
Basically we need to know the table names in yellowfin REPO DB which will have info on the user , the table-column(query) he/she tried to access while creating a SQL based report. NOTE: We have postrges report DB nad yellowfin 7.4.12