User With "read-only" Oracle Enterprise Manager (OEM) Role Can't Use Sql Tune When Connecting To DB With "dbsnmp" Credentials
(Doc ID 2054495.1)
Last updated on FEBRUARY 20, 2019
Enterprise Manager for Oracle Database - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 12.1] Information in this document applies to any platform.
When an attempt is made to tune SQL from the Oracle Enterprise Manager (OEM) 12c console, a "There was a problem tuning the SQL statement: Enterprise Manager has blocked you from performing this task as you are performing this operation using a READONLY connection" message is received as follows:
The user is logged in as "dbsnmp (read-only):
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!