SQL to find out unused permission lists

最新推荐文章于 2018-07-02 17:55:54 发布

conanxun

最新推荐文章于 2018-07-02 17:55:54 发布

阅读量61

点赞数

分类专栏： SQL

SQL 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

Below is the SQL to find out unused permission lists:

SELECT * FROM PSCLASSDEFN A
WHERE NOT EXISTS ( SELECT 'X' FROM PSUSERCLASSVW B WHERE A.CLASSID = B.CLASSID )
AND NOT EXISTS (SELECT 'X' FROM PSOPRDEFN B WHERE A.CLASSID = B.OPRCLASS)
AND NOT EXISTS (SELECT 'X' FROM PSOPRDEFN B WHERE A.CLASSID = B.PRCSPRFLCLS)
AND NOT EXISTS (SELECT 'X' FROM PSOPRDEFN B WHERE A.CLASSID = B.DEFAULTNAVHP)
AND NOT EXISTS (SELECT 'X' FROM PSOPRDEFN B WHERE A.CLASSID = B.ROWSECCLASS)
AND A.LASTUPDOPRID <> 'PPLSOFT'
ORDER BY CLASSID