My Oracle Support Banner

ATPD: How to Create Credentials in ATP Dedicated Instance - DBMS_CREDENTIAL (Doc ID 2614631.1)

Last updated on FEBRUARY 10, 2020

Applies to:

Autonomous Database Dedicated - Version NA and later
Information in this document applies to any platform.

Goal

How to create credentials in ATP Dedicated Database ?

When user tries create credentials with dbms_cloud package, whicih fails with following exception :


BEGIN
 DBMS_CLOUD.CREATE_CREDENTIAL(
   credential_name => 'bucket_cred',
   username => 'bucket_ods',
   password => 'xxxxxxxxxxxxxxx'
 );
END;
Error report -
ORA-06550: line 2, column 3:
PLS-00904: insufficient privilege to access object C##CLOUD$SERVICE.DBMS_CLOUD
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
06550. 00000 -  "line %s, column %s:\n%s"
*Cause:    Usually a PL/SQL compilation error.

 

Solution

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
Goal
Solution


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