Skip to content

How Do I Force Logout Admin if I don't have access to the Admin account?

John MolMember for 10 years 9 months
Created
2
2
0

I'm the P6 admin.  When I attempt to login as admin, Primavera tells me that admin is currently logged in.  It's been this way for a couple of days.  I've rebooted a couple of times since this has happend.  How can I force logout the admin acount if I can't access the admin account to force the logout?  Clear as mud?

 

Thanks!

2 replies

Oldest first
  1. 0
    Zoltan Palffy ·

    is you are using SQL then you

    is you are using SQL then 

    you will have to log into the database execute a querie

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

     

    If you run it and you get 1 as a result then 

     

    For all variables in the scripts below you are required to replace the variable (indicated by the <> symbols) with an actual variable. The greater than and less than signs should not be present in after the variables are populated.

    Example:
    <Enter User Name> becomes JohnDoe
    <Session Id> becomes 1234
     
    1.  Query the USESSION table for the users 'session_id':
    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>');
    2.  Delete the users records in the table UPKLIST (Does not apply for SQL Lite):
    Delete from UPKLIST where session_id = <session_id>;
    3.  Delete the users records in the table PROJSHAR:
    Delete from PROJSHAR where session_id = <session_id>;
    4.  Delete the users records in the table USESSION:
    Delete from USESSION where session_id = <session_id>;
     
  2. 0
    John Mol ·

    Thank you Zoltan!  We will

    Thank you Zoltan!  We will give this a try.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?