Oracle | DBMS_PSWMG_IMPORT

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

      

      PL/SQL procedure successfully completed.