Oracle | DBMS_XS_PRINCIPALS

Oracle DBMS_XS_PRINCIPALS Version 21c

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

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