Oracle | DBMS_CLOUD

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	DISABLE_CAPABILITY	REMOVE_CAPABILITY
CHECK_CAPABILITY	ENABLE_CAPABILITY	SET_CONFIG_PARAM
CHECK_CAPABILITY_FUNC	GET_CONFIG_PARAM

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');