Is it possible to Logout Primavera P6 Web through SQL Query?

Recently I noticed a question in Oracle community forum that sounds interesting to me. The question is ‘How to Log out a Primavera P6 EPPM user through SQL Query‘. I have not faced this type of scenario before, so I checked in to my local p6 weather is it possible.

I know the Primavera P6 inserts records into USESSION table when a user logs into Primavera P6 EPPM. Will it delete the USESSION table after the user Logs out? Yes, P6 deletes the record but not immediately when the user logs out. Instead, the P6 background job deletes the records on a scheduled interval.

The question here is Will deleting the user records in the USESSION table Log-out the user from Primavera P6? I initially thought so but went and tried. The answer is NO. We can not log out the user from P6 by deleting records from USESSION table. I am doing the following three steps to illustrate further

1. User Login to Primavera P6 EPPM

2. Deletes the USESSION table for the corresponding user

3. Refresh the P6 page to see the user is logged out

Let’s begin each points: 

1. User Login to Primavera P6 EPPM

Here, I logged into P6 as ADMIN user account 

2. Deletes the USESSION table for the corresponding User

Here, I deleted the session for user ADMIN once he logged in. The Query is below: 

delete from usession where user_id = (select user_id from users where user_name = ‘admin’)

3. Refresh the Primavera P6 

Here, I refresh the page and navigate to another tabs in P6 to check the user is signed out. Actually, the session is still valid

I checked the USESSION table again. P6 created a new session in the USESSION table for the user ADMIN. I have waited for 15 minutes and refreshed P6. It renders well.  

Conclusion

I guess Primavera P6 Web kills the Session through Java when the user Logs out from P6 (JAVA & JSESSIONID). And this is my knowledge about P6 and not from the Oracle documentation.