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 05, 2018

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.4.0 to 12.1.0.8.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):

	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 hundreds of Community platforms