SQL Query to List all users by Responsibility Name in Siebel

I had a random request come in which wanted the list of users by a responsibility name, some quick Google searches later realized that its not available readily on the Internet. So here it is for an easy reference guys.

SELECT U.LOGIN
FROM SIEBEL.S_USER U, SIEBEL.S_PER_RESP PER, SIEBEL.S_RESP R
WHERE U.ROW_ID = PER.PER_ID
AND R.ROW_ID = PER.RESP_ID
AND R.NAME LIKE 'Siebel Administrator';

You can play around and tweak it as you like for more complex results.