Process group and process access

--Accessible processes for a given user
select * from PS_PRCSDEFNGRP WHERE PRCSGRP IN
(select PRCSGRP from PSAUTHPRCS WHERE CLASSID IN (SELECT DISTINCT B.CLASSID FROM PSROLEUSER A, PSROLECLASS B
WHERE A.ROLENAME=B.ROLENAME
AND A.ROLEUSER='MSCCOMP_AV'
)
)

--Accessible permission lists for a given user
SELECT DISTINCT B.CLASSID FROM PSROLEUSER A, PSROLECLASS B
WHERE A.ROLENAME=B.ROLENAME
AND A.ROLEUSER='MSCCOMP_AV'

--Accessible process GROUPS for a given user
select * from PSAUTHPRCS WHERE CLASSID IN (SELECT DISTINCT B.CLASSID FROM PSROLEUSER A, PSROLECLASS B
WHERE A.ROLENAME=B.ROLENAME
AND A.ROLEUSER='MSCCOMP_AV'
)