Application designer objects / portal favorites / CI access

To find out who has access to Application designer objects

SELECT CLASSID FROM PSAUTHITEM WHERE MENUNAME='APPLICATION_DESIGNER' AND BARNAME='PAGE'


Portal Favourites for every user

SELECT * FROM PSPRUFDEFN


Access to Component interfaces - CI
SELECT * FROM PSAUTHBUSCOMP WHERE BCNAME = 'CI name'