Oracle DBMS_CLOUD_CAPABILITY
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 19c
What's New In 20c-21c

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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx