Oracle | DBMS_SODA_USER_DML

Oracle DBMS_SODA_USER_DML Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Simple Oracle Document Access DML utilities

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

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/prvtsodautil.plb

Subprograms

CREATE_USER	DROP_USER	GET_USERS
CREATE_USER_INNER	FIND_USER	GRANT_ROLE
DROP_ALL_ROLES	GET_CREDENTIAL	REVOKE_ROLE
DROP_ALL_USERS	GET_ROLES	SET_CREDENTIAL
DROP_ALL_USER_INFO	GET_USER	UPDATE_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;

      /

      *

      PLS-00904: insufficient privilege to access object DBMS_SODA_USER_DML

CREATE_USER_INNER (new 23ai)

Undocumented dbms_soda_user_dml.create_user_inner( p_owner IN VARCHAR2, p_user_name IN NVARCHAR2, p_description IN VARCHAR2, p_uid OUT RAW, p_current_uid IN RAW);

TBD

Undocumented dbms_soda_user_dml.drop_all_roles(p_owner IN VARCHAR2);

Protected by an ACCESSIBLE BY clause

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

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

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

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

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

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

Undocumented dbms_soda_user_dml.get_users( p_owner IN VARCHAR2, p_results OUT REF CURSOR)

Protected by an ACCESSIBLE BY clause

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

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

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

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_ADMIN

DBMS_SODADBMS_SODA_DOM

DBMS_SODA_USER_ADMIN

SODA for PL/SQL

What's New In 21c

What's New In 26ai

Morgan's Library Page Footer

This site is maintained by Daniel Morgan. Last Updated:

This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved