How to select all the OBS assigned to a User from the database in Primavera P6 EPPM

1. Login to ADMUSER schema and run the following query to get the user_id 

select user_id from admuser.users where user_name = ?

       2. Login to Admuser Schema , pass the USER_ID  and read all the Obs Assigned to the particular USER 

select UserObs.user_id, Obs.obs_name, UserObs.obs_id, UserObs.prof_id FROM admuser.obs Obs, 
admuser.userobs UserObs WHERE admuser.Obs.obs_id = admuser.UserObs.obs_id AND 
admuser.UserObs.user_id IN ( SELECT admuser.users.user_id FROM admuser.users
 WHERE admuser.users.user_id=? )
 order by obs_name