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:

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