Oracle DBMS_SODA_USER_DML
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 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 21c
What's New In 23c

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