Oracle 18cR3 DBMS_PSWMG_IMPORT

Oracle DBMS_PSWMG_IMPORT Version 18.3.0.1

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 Undocumented but appears to be used for importing and/or purging user password history and for importing the password verify function associated with a named profile.

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_STANDARD	USER_HISTORY$
DBMS_SQL	USER$

Data Types TYPE arrayOfHistoryRecords ....

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to the EXP_FULL_DATABASE and IMP_FULL_DATABASE roles.

Source {ORACLE_HOME}/rdbms/admin/prvtxpsw.plb

Subprograms

Import Password History dbms_pswmg_import.import_history( history_recs IN dbms_pswmg_import.arrayOfHistoryRecords, num_recs IN NUMBER);

TBD

IMPORT_PSW_VERIFY_FN

Import the Password Verify Function dbms_pswmg_import.import_psw_verify_fn( profile_name IN VARCHAR2, function_name IN VARCHAR2, function_body IN VARCHAR2);

TBD

PURGE_HISTORY

Purge Password History dbms_pswmg_import.purge_history(username IN VARCHAR2);

exec dbms_pswmg_import.purge_history('UWCLASS');