Oracle | DBMS_PSWMG_IMPORT

Oracle DBMS_PSWMG_IMPORT Version 23c

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$
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.

Some subprograms are protected 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 23c)

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 due to an ACCESSIBLE BY clause

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 due to an ACCESSIBLE BY clause