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 will be available on generic Linux platforms in January and soon on AIX and Windows

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