PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Locking Out users during installation of Tax Updates

edited Oct 9, 2012 3:14AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered
Hello – I am looking for some help with best practices.  When we apply tax updates to the Production environment, we do not shut down the application or web servers as the installers often need access to the system.  But I want to keep end users out.

 

What I would like to do, is do a Data Mover export of the PSOPRDEFN file, do a SQL update that sets the ACCTLOCK = 1 on the PSOPRDEFN table for all but the required users, then after the update is complete, restore the PSOPRDEFN to its previous state by importing the copy from earlier.

 

My problem with this is that any user that tries to access the system while locked out gets the 105 error “Your User ID and/or Password are invalid”.  This is because the 109 error “Your account has been disabled” has been removed as it was identified as a potential security vulnerability ( ID 1142880.1).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center