Oracle DBMS_XS_PRINCIPALS
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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-2019 Daniel A. Morgan All Rights Reserved