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

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>);<?xml:namespace prefix = o />

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>;

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.

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.