As a Admin, How to Disconnect P6 v8.2 User from Database (Resetting User Session Does Nothing)

Hi Benjamin,

The Reset User action should only be used when a user gets locked out after too many failed login attempts. What is it you are tyring to accomplish? If you are trying to restrict a user from logging in temporarily, you can remove their module access.

The user is appearing as though they are still logged in to the server even though they are not, wether it is the user nor properly logging out or not is incosequntial.  I need to close their session remotely.  

Remote ending of a P6 session is a minor feature included in our PROJECT WATCH software for P6 System Administrators.  With our software, the System Administrator can watch everything going on inside of EPPM or P6.  You can see each logged-on user and every opened schedule.  You can look deeply into a session of perform historical research about every major action performed.  Look for more at http://scheduleanalyzer.com/pwatch_brochure.htm.

One way to kill their session, which I use for locked out users, it to do it from the database.

If using SQL:

From SQL console type the following:

select session_id from USESSION where delete_session_id is NULL and user_id = (select user_id from users where user_name = <enter user name here>);

Once you have the session ID, type the following:

Delete from UPKLIST where session_id = <enter session id number here>;

Delete from PROJSHAR where session_id = <enter session id number here>;

Delete from USESSION where session_id = <enter session id number here>;

Ok, cool.  There's no way to do in P6.  :(