- 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
最新推荐文章于 2023-07-31 17:25:22 发布