Oracle DBMS_XS_PRINCIPALS
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Real Application Security
AUTHID CURRENT_USER
Dependencies
DBMS_RXS_LIB XS_PRINCIPAL_INT  
Documented Yes
First Available 11gR2
Security Model Owned by SYS with ? granted to the DBA role
Source {ORACLE_HOME}/rdbms/admin/prvtkzrxu.plb
Subprograms
 
ADD_PROXY_TO_SCHEMA
Add a proxy user to a database schema dbms_xs_principals.add_proxy_to_dbuser(
database_user IN VARCHAR2,
proxy_user    IN VARCHAR2,
is_external   IN BOOLEAN := FALSE);
TBD
 
REMOVE_PROXY_FROM_SCHEMA
Remove a proxy user from database schema dbms_xs_principals.remove_proxy_from_dbuser(
database_user IN VARCHAR2,
proxy_user    IN VARCHAR2);
TBD
 
SET_PASSWORD
Sets the schema password for a Principal dbms_xs_principals.set_password(
username  IN VARCHAR2,
password  IN VARCHAR2,
type      IN BINARY_INTEGER,
opassword IN VARCHAR2);
-- modified and simplified from the Oracle docs
BEGIN
  sys.xs_principal.create_role(name => 'Americas_sales', enabled => TRUE);
  sys.xs_principal.create_user(name =>' JAMES', schema => 'SH');
  sys.dbms_xs_principals.set_password('JAMES', "N0wAy8$", xs_principal.xs_sha512);
  sys.xs_principal.grant_roles('JAMES', 'Americas_sales');
END;
/
 
SET_VERIFIER
Creates a verifier for a Principal dbms_xs_principal.set_verifier(
username IN VARCHAR2,
verifier IN VARCHAR2,
type     IN PLS_INTEGER := XS_SHA512);
SQL> SELECT standard_hash('ZZYZX'') FROM dual;

STANDARD_HASH('ZZYZX')
----------------------------------------
04867015BE89A96E9FEE095F87B606595306D6AB

SQL> exec dbms_xs_principal.set_verifier('JAMES', standard_hash('ZZYZX'));

Related Topics
DBMS_XS_PRINCIPALS
DBMS_XS_SESSIONS
DBMS_XS_SESSIONS_FFI
DBMS_XS_SIDP
DBMS_XS_SYSTEM
DBMS_XS_SYSTEM_FFI
Packages
What's New In 12cR1
What's New In 12cR2
XS_ACL
XS_ADMIN_UTIL
XS_DATA_SECURITY
XS_DATA_SECURITY_UTIL
XS_DIAG
XS_DIAG_INT
XS_NAMESPACE
XS_SECURITY_CLASS

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-2017 Daniel A. Morgan All Rights Reserved