My Oracle Support Banner

DBConsole or OEM (Enterprise Manager Control) user needs "select any table" privilege in order to view Text Indexes (Doc ID 1478741.1)

Last updated on DECEMBER 09, 2014

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.2 to 12.1.0.2.0 [Release 10.2 to 12.1]
Oracle Text - Version 10.2.0.5 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

When logging into DB console as a user other than SYSDBA and attempting to view Text Indexes in OEM: Targets -> Databases -> choose DB -> Schema -> Text Manager -> Text indexes

The user may see the following error message:

 

Cause

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

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


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