Database Administration (MOSC)

MOSC Banner

Is it possible to restrict user access to certain tables or columns in logminer?

edited Oct 8, 2021 8:44PM in Database Administration (MOSC) Question
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:

  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:

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