Find Missing Component Interfaces for user

By Chris Malek | Wed, Oct 13, 2010

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; 

Article Categories