Oracle DBMS_XS_PRINCIPALS
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
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
 
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
Built-in Functions
Built-in Packages
DBMS_XS_PRINCIPALS
DBMS_XS_SESSIONS
DBMS_XS_SESSIONS_FFI
DBMS_XS_SIDP
DBMS_XS_SYSTEM
DBMS_XS_SYSTEM_FFI
What's New In 12cR2
What's New In 18cR3
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