General Information
Library Note
Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx .
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