How do I force users to "Pre-expired" in VigilEnt Password Manager for Oracle while integrated with (NETIQKB30494)

  • 7730494
  • 02-Feb-2007
  • 08-Sep-2008

Resolution

goal
How do I force users to "Pre-expired" in VigilEnt Password Manager for Oracle while integrated with PeopleSoft?

fact
VigilEnt Password Manager for Oracle 5.0

fact
VigilEnt Password Manager for Oracle 6.X

fact
VigilEnt Security Agent for Oracle 1.X

fix
To force PeopleSoft users to change their passwords during their next login, follow these steps:

  1. From a SQL prompt and log in as either SYS or SQLCQR.

  2. Run the following SQL statement.  (Note: Slight changes may be required depending on the environment.)

    update sqlcqr.sqlcqr_userdata
    set lastchanged_by = NULL
    where templateuser = 'Default';
    commit;

The SQL clause (where templateuser = 'Default';) will limit the update to users assigned to the Default template. This can be changed as needed.  The end result will be that each user will be "Pre-expired". These users will be prompted to change their passwords the next time they sign-on. Password histories will not be affected in any way by this action.

Additional Information

Formerly known as NETIQKB30494

Feedback service temporarily unavailable. For content questions or problems, please contact Support.