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

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.

Formerly known as NETIQKB30494