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