This SQL query is used to get user’s assigned responsibility name with start date and end end date of responsibility from user’s account, this query will extract all the assigned responsibility from the beginning till date. SELECT distinct fuser.USER_NAME USER_NAME , fuser.user_id , fuser.creation_date , fuser.last_update_date , fuser.LAST_LOGON_DATE , fuser.START_DATE , fuser.END_DATE , per.FULL_NAME FULL_NAME