Oracle DBMS_XS_PRINCIPALS
Version 19c

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 Real Application Security
AUTHID CURRENT_USER
Dependencies
XS_PRINCIPAL_INT    
Documented Yes
First Available 11.2
Security Model Owned by SYS with EXECUTE 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
XS_ACL
XS_ADMIN_UTIL
XS_DATA_SECURITY
XS_DATA_SECURITY_UTIL
XS_DIAG
XS_DIAG_INT
XS_NAMESPACE
XS_SECURITY_CLASS
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