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;
No comments:
Post a Comment