Is it possible to restrict user access to certain tables or columns in logminer?
Oracle Enterprise Version 19.9.0.0
I'm looking for suggestions on limiting access to certain data in logminer i.e. restricting access to SSN, Credit Card data, etc.
The user would be granted the following system rights/roles:
And granted access to the following system objects.
Then executing the following as the user, the SSN (and any other DML change for that matter) is revealed when updated:
I'm looking for suggestions on limiting access to certain data in logminer i.e. restricting access to SSN, Credit Card data, etc.
The user would be granted the following system rights/roles:
execute_catalog_role,
select any transaction,
select any dictionary,
logmining
And granted access to the following system objects.
grant select on SYSTEM.LOGMNR_COL$ to striim;
grant select on SYSTEM.LOGMNR_OBJ$ to striim;
grant select on SYSTEM.LOGMNR_USER$ to striim;
grant select on SYSTEM.LOGMNR_UID$ to striim;
Then executing the following as the user, the SSN (and any other DML change for that matter) is revealed when updated:
0