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

J
John Mol 👤 Member for 10 years 5 months

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!

Oracle Primavera - PM6
Z
Zoltan Palffy 👤 Member for 16 years 10 months
· Permalink

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

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts