Oracle 12c DBMS_XS

Oracle DBMS_XS_PRINCIPALS Version 12.1.0.2

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

ADD_PROXY_TO_SCHEMA	SET_PASSWORD	SET_VERIFIER
REMOVE_PROXY_FROM_SCHEMA

ADD_PROXY_TO_SCHEMA

Add a proxy user to a database schema dbms_xs_principals.add_proxy_to_dbuser( database_user IN VARCHAR2, proxy_user IN VARCHAR2, is_external IN BOOLEAN := FALSE);

TBD

REMOVE_PROXY_FROM_SCHEMA

Remove a proxy user from database schema dbms_xs_principals.remove_proxy_from_dbuser( database_user IN VARCHAR2, proxy_user IN VARCHAR2);

TBD

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