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

Member for

9 years 9 months

Thank you Zoltan!  We will give this a try.

Member for

16 years 3 months

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