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

All functionality is protected by an Accessible By clause.
Source {ORACLE_HOME}/rdbms/admin/dbmssodautil.sql
Subprograms
 
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SODA
DBMS_SODA_ADMIN
DBMS_SODA_DML
DBMS_SODA_DOM
DBMS_SODA_USER_DML
DBMS_SODA_UTIL
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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx