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 03, 2019

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):

	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

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