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)
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
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.