Oracle DBMS_BDSQL
Version 19.3

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 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 no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmsbdcluacc.sql
Subprograms
 
ADD_USER_MAP (new 19c)
Add a Big Data Cluster Acccess 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 (new 19c)
Remove a Big Data Cluster Acccess user map dbms_bdsql.remove_user_map(
cluster_name          IN VARCHAR2 DEFAULT '[DEFAULT]',
current_database_user IN VARCHAR2); -- NOT NULL
TBD

Related Topics
Built-in Functions
Built-in Packages
What's New In 18c
What's New In 19c

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