PeopleSoft Queries to identify the access details of a user

In this doodle, I have posted few SQL queries that can be used to get some of the access information of a PeopleSoft user.

Below SQL statement can be used to identify the list of Query Security Trees that an OPRID has access to. In PeopleSoft, Query Security Tree access is provided through permission list.

SELECT P.TREE_NAME,P.ACCESS_GROUP,P.ACCESSIBLE  FROM
PS_SCRTY_ACC_GRP P,
PSROLECLASS C,
PSROLEUSER R
WHERE R.ROLENAME = C.ROLENAME
AND P.CLASSID = C.CLASSID
AND R.ROLEUSER = oprid
 ORDER BY P.TREE_NAME

Below SQL can be used to identify through which permission list an OPRID has access to a particular component interface. In PeopleSoft, component interface access is provided through permission list.

SELECT DISTINCT P.CLASSID
FROM PSROLEUSER R,
PSROLECLASS C,
PSAUTHBUSCOMP P
WHERE R.ROLENAME = C.ROLENAME
AND P.CLASSID = C.CLASSID
AND P.BCNAME = 'CI_JOB_DATA'
AND R.ROLEUSER = oprid

Below SQL can be used to identify the list of component interfaces that an OPRID has access to.  In PeopleSoft, component interface access is provided through permission list.

SELECT DISTINCT P.BCNAME
FROM PSROLEUSER R,
PSROLECLASS C,
PSAUTHBUSCOMP P
WHERE R.ROLENAME = C.ROLENAME
AND P.CLASSID = C.CLASSID
AND R.ROLEUSER = oprid