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 is now availble. If you haven't you downloaded already: Why?

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