Check if user has access to CI

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' 

同步链接：http://blog.csdn.net/conanxun/article/details/7900660