My Oracle Support Banner

How To Setup And Use DBMS_CLOUD Package (Doc ID 2748362.1)

Last updated on APRIL 10, 2024

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

Goal

 This document covers the manual setup and configuration of DBMS_CLOUD and the proper configuration of users and roles for using DBMS_CLOUD

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
 Manual installation steps
 Installing DBMS_CLOUD
 Create SSL Wallet with Certificates
 Configure your Oracle environment to use the new SSL wallet
 Configure the Database with ACEs for DBMS_CLOUD
 Customers using an http proxy
 Verify Configuration of DBMS_CLOUD
 Configuring users or roles to use DBMS_CLOUD
 Grant the minimal privileges to a user or role for using DBMS_CLOUD
 Configure ACEs for a user or role to use DBMS_CLOUD
 Validate the proper user configuration and privilege (accessibility of wallet, privilege to use wallet, database-wide setting of wallet)
References

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