Autonomous Database (Shared) - dbms_credential.create_credential failed with ORA-27486
(Doc ID 2746284.1)
Last updated on DECEMBER 03, 2023
Applies to:
Autonomous Database on Shared Infrastructure - Version N/A and laterInformation in this document applies to any platform.
Symptoms
In Autonomous Database (Shared), the create credential using DBMS_CREDENTIAL.CREATE_CREDENTIAL failed with ORA-27486
SQL> execute dbms_credential.create_credential(credential_name => 'OBJ_STORE_CRED',username => 'nkoottal', password => 'xxxxx');
BEGIN dbms_credential.create_credential(credential_name => 'OBJ_STORE_CRED',username => 'nkoottal', password => 'xxxx'); END;
*
ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_CREDENTIAL", line 44
ORA-06512: at "SYS.DBMS_ISCHED", line 2487
ORA-06512: at "SYS.DBMS_CREDENTIAL", line 32
ORA-06512: at line 1
Cause
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 |
Cause |
Solution |