Find Unused Permission Lists

By Chris Malek | Wed, Oct 13, 2010

This query should find unused permission lists that could be deleted.

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 ;

Article Categories

Security

Author Info

Chris Malek

Chris Malek is a PeopleTools® Technical Consultant with two decades of experience working on PeopleSoft enterprise software projects. He is available for consulting engagements.

About Chris Work with Chris

PeopleSoft REST APIs for AI, Modern Apps, and Integrations

PeopleSoft Simple Web Services (SWS)

Turn PeopleSoft data into clean REST APIs for AI integrations, modern applications, and vendor data feeds. Configuration-driven — no PeopleCode required.

Deploy production APIs in under 5 minutes
AI and LLM ready (RAG, chatbots, intelligent search)
JSON, XML, and CSV output
Zero modifications to delivered PeopleSoft objects

Integration Broker - The Missing Manual

I am in the process of writing a book called "Integration Broker - The Missing Manual" that you can read online.

Read Online