My Oracle Support Banner

EM13c : Trying To Execute SQL via REST API Fails - Credential not found (Doc ID 2780355.1)

Last updated on SEPTEMBER 29, 2021

Applies to:

Enterprise Manager Base Platform - Version and later
Information in this document applies to any platform.


In Enterprise Manager (EM) Cloud Control, end users get a named credential for connecting to pluggable database, but they are not the owners of this named credential.

1. To create EM user:

Setup --> Security --> Administrators

Create Administrator: ABC
Super Administrator Yes

2. To create Named Credentials

Setup --> Security --> Named Credentials

Create Named Credential: NC_ABC

3. Grant privilege to Named Credentials

Setup --> Security --> Named Credentials

3.1) Search for the desired credential.NC_ABC

3.2) Click Manage Access

3.3) Click Add Grant, select desired users

3.4) Update privilege to either "Edit Credential", "Full Credential" or "View Credential"

3.5) Click save.

4. Additionally, check the OMS property must be set to true using emctl to enable REST operations on the database target.



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

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