Check if user has access to CI

来源:互联网 发布:电视什么牌子好 知乎 编辑:程序博客网 时间:2024/05/12 12:03
 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'

原创粉丝点击