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 APRIL 01, 2020

Applies to:

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


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:



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.