My Oracle Support Banner

LogMiner Related Privileges Are Missing from SYSTEM_PRIVILEGE_MAP After Upgrade to (Doc ID 2197180.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1]
Information in this document applies to any platform.


The following LogMiner related privilege should be listed while querying system_privilege_map in 12.1:

select * from system_privilege_map where name like '%LOGMINING';

---------- ---------------------------------------- ----------

But, due to unpublished Bug 16684631 -LOGMINING PRIVILEGE NOT DISPLAYED IN SYSTEM_PRIVILEGE_MAP OF AN UPGRADED DB, the query above does not return this row for a database that was upgraded to

When faced with the consequences of unpublished Bug 16684631, you have at least two options to chose from as workarounds.

1) Upgrade the affected database to using an in-place upgrade approach, since the associated upgrade scripts of do add the LOGMINING system privilege to the target database.
2) Manually add the LOGMINING system privilege to the affected database.

This document provides a manual set of commands to use to add the missing LOGMINING system privilege metadata into a database that was upgraded to using the in-place upgrade approach.


 Applies only to databases that were upgraded from a previous version using an in-place upgrade approach.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.