Oracle | DBMS_PSWMG_IMPORT

Oracle DBMS_PSWMG_IMPORT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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.