My Oracle Support Banner

EM 13c: Run SQL Job On Database Target Fails With Error "Required Privilege: Run any sql on Database" (Doc ID 2892637.1)

Last updated on AUGUST 28, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When logged into the EM Console as a Non-Super Administrator and navigating to Targets > Database > Performance > Run Host Command the following error is displayed:

Insufficient Privilege
User <Non-SuperAdmin_User> does not have sufficient privileges to perform the operation.
Operation: Access to Enterprise Manager management Page
Required Privilege: Run any sql on Database
Contact Enterprise Manager Administrator to get the privileges required to perform the operation.

 EM User is already granted target privilege "Run any sql on Database" on Database targets.

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!


In this Document
Symptoms
Cause
Solution


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