Oracle | DBMS_SODA_USER_DML

Oracle DBMS_SODA_USER_DML Version 21c

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	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

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

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_SODA_DOM

DBMS_SODA_USER_ADMIN

SODA for PL/SQL

What's New In 19c

What's New In 20c-21c

Morgan's Library Page Footer

This site is maintained by Dan Morgan. Last Updated:

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