Find Missing Component Interfaces for user

转载于 2013-02-18 21:27:09 发布 · 127 阅读

·

0

·

0

CI 专栏收录该内容

7 篇文章

订阅专栏

本文提供了一段SQL查询语句，用于找出特定用户在系统中尚未获取的组件接口。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;