Oracle DBMS_CLOUD_CAPABILITY
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Procedures to check DBMS_CLOUD capabilities
AUTHID DEFINER
Constants
Name Data Type Value
 General
 M_VCSIZ_4K PLS_INTEGER 4000
 Capabilities
CHANGE_CHAR_SET DBMS_ID 'CHANGE CHARACTER SET'
DBLINK_USING_CRED DBMS_ID 'DBLINK USING CREDENTIAL'
OCI_NATIVE_CRED DBMS_ID 'OCI_NATIVE_CREDENTIAL'
ROTATE_ENC_KEY DBMS_ID 'ROTATE_ENC_KEY'
SEED_CACHING DBMS_ID 'SEED_CACHING'
 Capability Statuses
CAP_STATUS_DISABLED DBMS_ID 'DISABLED'
CAP_STATUS_ENABLED DBMS_ID 'ENABLED'
Dependencies
DBMS_STANDARD    
Documented No
Exceptions
Error Code Reason
20001 EXCP_CAPABILITY_EXISTS
20002 EXCP_INVALID_OPERATION
20998 EXCP_DISABLED_CAPABILTY
First Available 21c
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbms_cloud_capability.sql
{ORACLE_HOME}/rdbms/admin/prvt_cloud_capability_body.plb
SQL> @?/rdbms/admin/dbms_cloud_capability.sql

Session altered.

SP2-0808: Package created with compilation warnings

Errors for PACKAGE DBMS_CLOUD_CAPABILITY:

LINE/COL ERROR
------------------------------------------------------------------------
1/1 PLW-05018: unit DBMS_CLOUD_CAPABILITY omitted optional AUTHID
clause; default value DEFINER used

Session altered.

SQL> @?/rdbms/admin/prvt_cloud_capability_body.plb

Session altered.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_CLOUD_CAPABILITY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
45/9 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY
compiler hint

Session altered.
Subprograms
 
ADD_CAPABILITY (new 21c)
Adds a Cloud capability dbms_cloud_capability.add_capability(
capability IN VARCHAR2,
status     IN VARCHAR2 DEFAULT 'DISABLED');
exec dbms_cloud_capability.add_capability('ENABLED');
 
CHECK_CAPABILITY (new 21c)
Verifies the status of a DBMS_CLOUD capability and raise an exception if the capability is disabled or not found. dbms_cloud_capability.check_capability(capability IN VARCHAR2);
exec dbms_cloud_capability.check_capability('DBLINK USING CREDENTIAL');
 
CHECK_CAPABILITY_FUNC (new 21c)
Check the status of a DBMS_CLOUD capability and return the status dbms_cloud_capability.check_capability_func(capability IN VARCHAR2) RETURN BOOLEAN;
BEGIN
  IF dbms_cloud_capability.check_capability_func('OCI_NATIVE_CREDIBILITY') THEN
    dbms_output.put_line('T');
  ELSE
    dbms_output.put_line('F');
  END IF;
END;
/
 
DISABLE_CAPABILITY (new 21c)
Disables a Cloud capability dbms_cloud_capability.disable_capability(capability IN VARCHAR2);
exec dbms_cloud_capability.disable_capability('DBLINK USING CREDENTIAL');
 
ENABLE_CAPABILITY (new 21c)
Enables a Cloud capability dbms_cloud_capability.enable_capability(capability IN VARCHAR2,);
exec dbms_cloud_capability.enable_capability('DBLINK USING CREDENTIAL');
 
GET_CONFIG_PARAM (new 21c)
Returns a Cloud configuration parameter value dbms_cloud_capability.get_config_param(param_name IN VARCHAR2) RETURN VARCHAR2;
SELECT dbms_cloud_capability.get_config_param('ROTATE_ENC_KEY')
FROM dual;

DBMS_CLOUD_CAPABILITY.GET_CONFIG_PARAM('ROTATE_ENC_KEY')
--------------------------------------------------------
 
 
REMOVE_CAPABILITY (new 21c)
Removes a Cloud capability dbms_cloud_capability.remove_capability(capability IN VARCHAR2);
exec dbms_cloud_capability.remove_capability('DBLINK USING CREDENTIAL');
 
SET_CONFIG_PARAM (new 21c)
Sets a Cloud configuration parameter value dbms_cloud_capability.set_config_param(
param_name  IN VARCHAR2,
param_value IN VARCHAR2);
exec dbms_cloud_capability.set_config_param('ROTATE_ENC_KEY');

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_CLOUD
DBMS_CLOUD_ADMIN_INTERNAL
DBMS_CLOUD_CORE
DBMS_CLOUD_INTERNAL
DBMS_CLOUD_MACADM
DBMS_CLOUD_REQUEST
DBMS_CLOUD_TASK
DBMS_CLOUD_TYPES
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx