Oracle | DBMS_XS_PRINCIPALS

Oracle DBMS_XS_PRINCIPALS Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Real Application Security

AUTHID CURRENT_USER

Dependencies

XS_PRINCIPAL

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

SET_VERIFIER

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'));