Please enable JavaScript to view this site.

The Oracle LogMiner Capture requires special user privileges and preparation to access and read the Oracle Recovery Logs using the Oracle LogMiner API.

Enable LogMiner functionality

•ALTER DATABASE ADD SUPPLEMENTAL LOG DATA provides the minimal level of database metadata required by the Oracle LogMiner.

The following GRANTS are required:

1.GRANT LOGMINING TO <sqdata_user>;  (only required for Oracle 12 and above)

2.EXECUTE authority:

a.GRANT EXECUTE_CATALOG_ROLE TO <sqdata_user>;

b.GRANT EXECUTE  DBMS_LOGMNR TO <sqdata_user>;

c.GRANT EXECUTE  DBMS_LOGMNR_D TO <sqdata_user>;

3.SELECT authority:

a.GRANT SELECT ON V$LOGFILE TO <sqdata_user>;

b.GRANT SELECT ON V$ARCHIVED_LOG TO <sqdata_user>;

c.GRANT SELECT ON V$LOG TO <sqdata_user>;

d.GRANT SELECT ON V$DATABASE TO <sqdata_user>;

e.GRANT SELECT ON V$LOG_HIST TO <sqdata_user>;

f.GRANT SELECT ON V$LOGMNR_CONTENTS TO <sqdata_user>;

g.GRANT SELECT ON V$INSTANCE TO <sqdata_user>;

h.GRANT SELECT ON V$THREAD TO <sqdata_user>;

i.GRANT SELECT ANY TRANSACTION TO <sqdata_user>;  authority to allow for querying the Oracle FLASHBACK_QUERY_TRANSACTION view

j.GRANT SELECT MAX(SCN_BAS) from SYS.SMON_SCN_TIME  TO <sqdata_user>; (9i only)

Notes:

•The LogMiner Capture requires Oracle client access (same requirements as sqlplus)

•Each Oracle table to be captured also requires:
 
ALTER TABLE <schema.tablename> ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;