SELECT C.ROLEUSER
,B.ROLENAME
,A.CLASSID, -- OPRID
A.BCNAME -- CI
, A.BCMETHOD
FROM PSAUTHBUSCOMP A,
PSROLECLASS B,
PSROLEUSER C
WHERE C.ROLENAME = B.ROLENAME
AND B.CLASSID = A.CLASSID
AND C.ROLEUSER = 'PS'
AND A.BCNAME = 'USER_PROFILE'
Check if user has access to CI
最新推荐文章于 2022-05-10 22:44:34 发布