Primavera (MOSC)

MOSC Banner

Unlock P6 users from the database

edited May 18, 2016 12:05PM in Primavera (MOSC) 3 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center