Oracle DBMS_XS_PRINCIPALS
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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