I am a P6v8.2 Admin and does anyone know how to cancel a user's connection to the database in P6v8.2. Resetting their session in the web Admin Portal does nothing. I don't want to disconnect them using my my server admin rights.
As a Admin, How to Disconnect P6 v8.2 User from Database (Resetting User Session Does Nothing)
Featured Partner
Top Posters
Sunchana Johnston
12 posts
Akram Hammam Mohamed
17 posts
Sagar Raut
14 posts
Patricio_aoa
0 posts
James Williams
75 posts
Philip Assou-Dodji
1 posts
jeoffrey reyes
15 posts
markg
0 posts
Manjeet Yadav
0 posts
Pan
0 posts
Our Partners
Ok, cool. There's no way to do in P6. :(
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.
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.
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.