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

Security Component Interface

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
Looking for pain-free PeopleSoft web services? 😀
PeopleSoft Simple Web Services (SWS)

Introducing a small but powerful PeopleSoft bolt-on that makes web services very easy. If you have a SQL statement, you can turn that into a web service in PeopleSoft in a few minutes.

Read More & Purchase
Book
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