By | 13 October 2010

Find Missing Component Interfaces for user

This sql should find component interfaces that a specific user does not have.

 SELECT A.BCNAME,
  A.BCDISPLAYNAME,
A.MENUNAME ,A.DESCR, A.DESCRLONG
      FROM
PSBCDEFN A WHERE
NOT EXISTS (SELECT B.CLASSID FROM
PS_PSBCDEFN_VW B, PSOPRCLS C WHERE
B.BCNAME = A.BCNAME AND
C.OPRCLASS = B.CLASSID
AND C.OPRID = 'UserID' )
ORDER BY A.BCNAME; 

Do you want to become a CI Expert?

If you want to learn more about developing using Component Interface then check out our CI Training Video.