How to get Siebel user responsibilities from database through Sql query

SELECT
u.LOGIN as "User ID"
,res.NAME as "Responsibility"

FROM S_USER u
left join S_PER_RESP ri on ri.PER_ID = u.ROW_ID
left join S_RESP res on res.ROW_ID = ri.RESP_ID

WHERE  u.LOGIN IN ('USER.NAME')
ORDER BY u.LOGIN