Oracle | DBMS_SODA_USER

Oracle DBMS_SODA_USER_ADMIN 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 Utility functions for use by the JSON Collections API. These functions are only allowed to be invoked by xdb.dbms_collections for accessing SYS objects in support of Simple Oracle Document Access.

AUTHID CURRENT_USER

Dependencies

DBMS_SODA_USER_DML

Documented No

First Available 19c

Security Model Owned by XDB with EXECUTE granted to the SODA_APP role.

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

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

Subprograms

CREATE_USER	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
DROP_USER	GET_USERS

CREATE_USER

Creates a user for the current schema owned by CURRENT_USER dbms_soda_user_admin.create_user( p_user_name IN NVARCHAR2, p_description IN VARCHAR2, p_uid OUT RAW);

TBD

DROP_ALL_ROLES

Drop all roles granted from the current schema dbms_soda_user_admin.drop_all_roles;

exec dbms_soda_user_admin.drop_all_roles;

      

      PL/SQL procedure successfully completed.

DROP_ALL_USERS

Drop all users owned by the current schema dbms_soda_user_admin.drop_all_users;

exec dbms_soda_user_admin.drop_all_users;

      

      PL/SQL procedure successfully completed.

DROP_ALL_USER_INFO

Drop all user info in xdb.json$ tables dbms_soda_user_admin.drop_all_user_info(p_owner IN VARCHAR2);

TBD

DROP_USER

Drop a user owned by the current schema CURRENT_USER dbms_soda_user_admin.drop_user( p_user_name IN VARCHAR2, p_uid OUT RAW);

TBD

FIND_USER

Get information about a user given the name and owner dbms_soda_user_admin.find_user( p_owner IN VARCHAR2, p_user_name IN NVARCHAR2, p_uid OUT RAW);

TBD

GET_CREDENTIAL

Returns a credential and the UUID for a user dbms_soda_user_admin.get_credential( p_user_name IN NVARCHAR2, p_credential_type IN VARCHAR2, p_credential OUT VARCHAR2, p_uid OUT RAW);

TBD

GET_ROLES

Returns roles for a user given the UUID dbms_soda_user_admin.get_roles( p_uid IN RAW, p_results OUT sys_refcursor);

TBD

GET_USER

Returns information about a user given the ID. dbms_soda_user_admin.get_user( p_uid IN RAW, p_owner OUT VARCHAR2, p_user_name OUT NVARCHAR2, p_created_on OUT TIMESTAMP, p_description OUT VARCHAR2);

TBD

GET_USERS

Get all users owned by the current schema dbms_soda_user_admin.get_users(p_results OUT sys_refcursor);

TBD

GRANT_ROLE

Add a role to the specified user given the UUID. Will create an assignment for the schema owned by CURRENT_USER. dbms_soda_user_admin.grant_role( p_uid IN RAW, p_role_name IN VARCHAR2);

TBD

REVOKE_ROLE

Remove a role from the specified user given the UUID. Will work for the schema owned by CURRENT_USER. dbms_soda_user_admin.revoke_role( p_uid IN RAW, p_role_name IN VARCHAR2);

TBD

SET_CREDENTIAL

Create or updates the credential for a user given the UUID. Will work only for users that are owned by the CURRENT_USER. dbms_soda_user_admin.set_credential( p_uid IN RAW, p_credential_type IN VARCHAR2, p_credential IN VARCHAR2);

TBD

UPDATE_USER

Change the description for a user for the current schema dbms_soda_user_admin.update_user( p_uid IN RAW, p_description IN VARCHAR2);

TBD