Primavera (MOSC)

MOSC Banner

Force Termination of User Session - Best Practice?

edited Dec 13, 2010 4:27AM in Primavera (MOSC) 1 commentAnswered
We occassionally need to terminate user sessions to go "exclusive" on a project or for a rebuild or other emergent maintenance and the user is not available to logoff.  We run the following sql to "kill" the user session and have experienced no problems, but consultants have advised us that this approach can cause unanticipated problems.

UPDATE USESSION
SET DELETE_SESSION_ID = 0
WHERE (USER_ID =
      (SELECT USER_ID AS EXPR1
       FROM USERS
       WHERE (UPPER(USER_NAME) = UPPER(:USERID))))


What are the potential negative impacts of this approach, if any?

Is there a utility or other method available that avoids these pitfalls?

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