Oracle DBMS_SODA_USER_DML
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 Undocumented
AUTHID DEFINER
Dependencies
DBMS_SODA_USER_ADMIN JSON$USERS JSON$USER_ROLES
JSON$COLLECTION_METADATA JSON$USER_CREDENTIALS  
Documented No
First Available 19c
Security Model Owned by XDB with no privileges granted

The package is protected by an ACCESSIBLE BY clause
Source {ORACLE_HOME}/rdbms/admin/prvtsodautil.plb
Subprograms
 
CREATE_USER
Undocumented dbms_soda_user_dml.create_user(
p_owner       IN  VARCHAR2,
p_user_name   IN  NVARCHAR2,
p_description IN  VARCHAR2,
p_uid         OUT RAW);
DECLARE
 outVal RAW(2048);
BEGIN
  xdb.dbms_soda_user_dml.create_user('C##UWCLASS', 'C##ZZYZX', 'Test', outVal);
  dbms_output.put_line(outVal);
END;
/
  xdb.dbms_soda_user_dml.create_user('C##UWCLASS', 'C##ZZYZX', 'Test', outVal);
  *
ERROR at line 4:
ORA-06550: line 4, column 3:
PLS-00904: insufficient privilege to access object DBMS_SODA_USER_DML
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
 
DROP_ALL_ROLES
Undocumented dbms_soda_user_dml.drop_all_roles(p_owner IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
DROP_ALL_USERS
Undocumented dbms_soda_user_dml.drop_all_users(p_owner IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
DROP_ALL_USER_INFO
Undocumented dbms_soda_user_dml.drop_all_user_info(p_owner IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
DROP_USER
Undocumented dbms_soda_user_dml.drop_user(
p_owner     IN  VARCHAR2,
p_user_name IN  NVARCHAR2,
p_uid       OUT RAW);
Protected by an ACCESSIBLE BY clause
 
FIND_USER
Undocumented dbms_soda_user_dml.find_user(
p_owner     IN  VARCHAR2,
p_user_name IN  NVARCHAR2,
p_uid       OUT RAW);
Protected by an ACCESSIBLE BY clause
 
GET_CREDENTIAL
Undocumented dbms_soda_user_dml.get_credential(
p_owner           IN  VARCHAR2,
p_user_name       IN  NVARCHAR2,
p_credential_type IN  VARCHAR2,
p_credential      OUT VARCHAR2,
p_uid             OUT RAW);
Protected by an ACCESSIBLE BY clause
 
GET_ROLES
Undocumented dbms_soda_user_dml.get_roles(
p_uid     IN  RAW,
p_owner   IN  VARCHAR2,
p_results OUT REF CURSOR);
Protected by an ACCESSIBLE BY clause
 
GET_USER
Undocumented dbms_soda_user_dml.get_user(
p_uid         IN  RAW,
p_owner       OUT VARCHAR2,
p_user_name   OUT NVARCHAR2,
p_created_on  OUT TIMESTAMP,
p_description OUT VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
GET_USERS
Undocumented dbms_soda_user_dml.get_users(
p_owner   IN  VARCHAR2,
p_results OUT REF CURSOR)
Protected by an ACCESSIBLE BY clause
 
GRANT_ROLE
Undocumented dbms_soda_user_dml.grant_role(
p_uid       IN RAW,
p_owner     IN VARCHAR2,
p_role_name IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
REVOKE_ROLE
Undocumented dbms_soda_user_dml.revoke_role(
vp_uid      IN RAW,
p_owner     IN VARCHAR2,
p_role_name IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
SET_CREDENTIAL
Undocumented dbms_soda_user_dml.set_credential(
p_uid             IN RAW,
p_owner           IN VARCHAR2,
p_credential_type IN VARCHAR2,
p_credential      IN VARCHAR2);
Protected by an ACCESSIBLE BY clause
 
UPDATE_USER
Undocumented dbms_soda_user_dml.update_user(
p_uid         IN RAW,
p_owner       IN VARCHAR2,
p_description IN VARCHAR2);
Protected by an ACCESSIBLE BY clause

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SODA
DBMS_SODA_ADMIN
DBMS_SODA_DML
DBMS_SODA_DOM
DBMS_SODA_USER_ADMIN
DBMS_SODA_UTIL
SODA for PL/SQL
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx