What are the Oracle database objects for VigilEnt Password Manager for Oracle while integrated with (NETIQKB30556)

goal
What are the Oracle database objects for VigilEnt Password Manager for Oracle while integrated with PeopleSoft?

fact
VigilEnt Password Manager for Oracle 6.x

fact
VigilEnt Security Agent for Oracle 1.x

fix

Please refer to the following list of database objects found in all Password Manager v6 databases:

• PACKAGE SQLCQR_PRIVATE_PKG
• PACKAGE BODY SQLCQR_PRIVATE_PKG
• PACKAGE SQLCQR_PWD
• PACKAGE BODY SQLCQR_PWD
• FUNCTION SQLCQR_PRIVATE_PKG_VERSION
• FUNCTION SQLCQR_VERIFY_FUNCTION_VERSION
• FUNCTION SYS.SQLCQR_VERIFY_FUNCTION
• TABLE PASSWORD_DICTIONARY
• TABLE SQLCQR_ADMINISTRATORS
• TABLE SQLCQR_PWDMGR_ERRLOG
• TABLE SQLCQR_PWDMGR_NOTIFY_PARAMS
• TABLE SQLCQR_PWDMGR_PARAMS
• TABLE SQLCQR_PWDMGR_PARTNERLIST
• TABLE SQLCQR_PWDMGR_PARTNERS2SYNC
• TABLE SQLCQR_PWDMGR_PENDING_NOTIFY
• TABLE SQLCQR_PWDMGR_REPORTS
• TABLE SQLCQR_PWDMGR_REPORT_COLUMNS
• TABLE SQLCQR_PWDMGR_REPORT_FILTERS
• TABLE SQLCQR_USERDATA
• VIEW SQLCQR_USERDATA_TEMPLATED_VIEW
• INDEX SYS_C0011861 (Oracle created index)
• INDEX SYS_C0011864 "
• INDEX SYS_C0011880 "
• INDEX SYS_C0011884 "
• INDEX SYS_C0011890 "
• INDEX SYS_C0011892 "
• INDEX SYS_C0011896 "
• INDEX SYS_C0011900 "
• INDEX SYS_C0011905 "
• INDEX SYS_C0011910 "
• DBMS_JOB sqlcqr.sqlcqr_private_pkg.DONOTIFYSCAN
• DBMS_JOB sqlcqr.sqlcqr_private_pkg.sqlcqr_partner2sync
• DBMS_JOB sqlcqr.sqlcqr_private_pkg.sqlcqr_audit_scan
• DBMS_JOB sqlcqr.sqlcqr_private_pkg.sqlcqr_pwd_listener

The following is a list of database objects for Password Manager v6 while integrated with PeopleSoft.

API 2 tier:

• PROCEDURE SQLCQR_PWD_CHECKANDSET_PROC
• FUNCTION SQLCQR_LOGINCHECK
• FUNCTION SQLCQR_PWD_CHECKANDSET
• TRIGGER SQLCQR_PWDCHANGE_TRIGGER_PPL

API 3 tier:

• PROCEDURE PPLSOFT_LOGIN_EVENT
• PROCEDURE SQLCQR_PWDDISABLE_NOTIFICATION
• UNIX process for the 3-tier Breakin Scanner

Formerly known as NETIQKB30556