Oracle | DBMS

Oracle DBMS_BDSQL 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 Big Data Cluster Access Utility

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
General
HADOOP_USER_MAX_LEN	PLS_INTEGER	30
NAMESPACE_MAX_LEN	PLS_INTEGER	30

Dependencies

ALL_USERS	DBMS_ASSERT	DBMS_STANDARD
BDSQL_USER_MAP

Documented No

Exceptions

Error Code	Reason
ORA-20865	INVALID_USERNAME
ORA-20886	AMBIGUOUS_ROW
ORA-20887	HADOOP_USER_TOO_LONG
ORA-20888	NAMESPACE_TOO_LONG
ORA-20889	NOTHING_TO_REVOKE
ORA-20890	NO_ROWS_FOUND
ORA-20891	INVALID_NAME_ASSERT
ORA-20892	INVALID_NAME_FOR_US
ORA-20893	NULL_SYSCTX_PARM_HADOOP_PASSED
ORA-20894	ROLE_PRIV_ERR
ORA-20895	DUPLICATE_ROW
ORA-20896	INVALID_USERENV_ATTRIBUTE
ORA-20897	NULL_FOURTH_PARAMETER_PASSED
ORA-20898	NULL_CURRENT_DB_USER_PASSED
ORA-20899	NULL_CLUSTER_NAME_PASSED
ORA044003	ASSERT_INVALID_NAME

First Available 12.2

Security Model Owned by SYS with EXECUTE granted to the BDSQL_ADMIN role

Source {ORACLE_HOME}/rdbms/admin/dbmsbdcluacc.sql

Subprograms

ADD_USER_MAP

REMOVE_USER_MAP

ADD_USER_MAP

Add a Big Data Cluster Access user map dbms_bdsql.add_user_map( cluster_name IN VARCHAR2 DEFAULT '[DEFAULT]', current_database_user IN VARCHAR2, -- NOT NULL syscontext_namespace IN VARCHAR2, -- DEFAULT NULL syscontext_parm_hadoop_user IN VARCHAR2); -- NOT NULL

TBD

REMOVE_USER_MAP

Remove a Big Data Cluster Access user map dbms_bdsql.remove_user_map( cluster_name IN VARCHAR2 DEFAULT '[DEFAULT]', current_database_user IN VARCHAR2); -- NOT NULL

TBD