Oracle | DBMS_PSWMG_IMPORT

Oracle DBMS_PSWMG_IMPORT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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$
DBMS_PDB	KUPP$PROC	USER_HISTORY$
DBMS_SQL

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.

Direct access to this package is prevented by an Accessible By clause.

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

Subprograms

IMPORT_HISTORY	IMPORT_PSW_VERIFY_FN	PURGE_HISTORY
IMPORT_HISTORY_INSERT

IMPORT_HISTORY

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

TBD

IMPORT_HISTORY_INSERT (new 23ai)

Undocumented but appears to import an owner-password association dbms_pswmg_import.import_history_insert( usernum IN NUMBER, password IN VARCHAR2, pswd_date IN VARCHAR2;

No demo possible

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

No demo possible