Unlock P6 users from the database
Hi,
Other than unlocking users from the Primavera SQL database directly using the scripts below, is there any other way (i.e) from the application that this can be done.
We currently use both P6 R7 and P6 R8.2 and I would like the P6 admin to be able to unlock users locked in the database. The databases are hosted on a shared server which the P6 admin has no access to
select session_id from USESSION where delete_session_id is NULL and user_id = (select user_id from users where user_name = 'y');
Delete from UPKLIST where session_id = x;