EM 13c: After Upgrading from 12c, Run SQL from Targets > Databases > Performance Fails With "User xxxx does not have sufficient privileges to perform the operation."
(Doc ID 2657683.1)
Last updated on APRIL 17, 2020
Applies to:Enterprise Manager for Oracle Database - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
EM is upgraded from 188.8.131.52 to 13c.
From 13c EM Console, Targets > Databases > Performance > Run SQL Fails With the following error though the administrator has FULL privileges on the database target.
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
If we grant "FULL ANY TARGET" it works. But this is a security violation as the administrators should not have FULL ANY TARGET privilege.
Removing "FULL ANY TARGET" and granting "FULL" to the assigned targets ends up in the error.
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