Oracle | DBMS_SODA_USER

Oracle DBMS_SODA_USER_ADMIN 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 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.

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 means of 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); PRAGMA SUPPLEMENTAL_LOG_DATA(CREATE_USER, AUTO);

TBD

DROP_ALL_ROLES

Drop all roles granted from the current schema dbms_soda_user_admin.drop_all_roles; PRAGMA SUPPLEMENTAL_LOG_DATA(DROP_ALL_ROLES, AUTO);

exec dbms_soda_user_admin.drop_all_roles;

DROP_ALL_USERS

Drop all users owned by the current schema dbms_soda_user_admin.drop_all_users; PRAGMA SUPPLEMENTAL_LOG_DATA(DROP_ALL_USERS, AUTO);

exec dbms_soda_user_admin.drop_all_users;

DROP_ALL_USER_INFO

Drop all user info in xdb.json$ tables dbms_soda_user_admin.drop_all_user_info(p_owner IN VARCHAR2); PRAGMA SUPPLEMENTAL_LOG_DATA(DROP_ALL_USER_INFO, AUTO);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(DROP_USER, AUTO);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(FIND_USER, NONE);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(GET_CREDENTIAL, NONE);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(GET_ROLES, NONE);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(GET_USER, NONE);

TBD

GET_USERS

Get all users owned by the current schema dbms_soda_user_admin.get_users(p_results OUT sys_refcursor); PRAGMA SUPPLEMENTAL_LOG_DATA(GET_USERS, NONE);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(GRANT_ROLE, AUTO);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(REVOKE_ROLE, AUTO);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(SET_CREDENTIAL, AUTO);

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); PRAGMA SUPPLEMENTAL_LOG_DATA(UPDATE_USER, AUTO);

TBD