Back End Role InsertThis is a script to show you how to insert a role from the back end.
INSERT INTO
PSROLEUSER (ROLEUSER, ROLENAME, DYNAMIC_SW)
VALUES ('AKSHATA','PeopleTools','N')
Find Unused Permission Lists
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 ;
Find Portal CREF in Navigation
Here is a quick way to find where a component shows up in the portal
navigation for a given component. In this example, we are going to
find the navigation for the JOB_DATA component.
Step 1.) Find the Portal Object Name the component was registered
under. This object name will be returned by the PORTAL_OBJNAME column
from the following sql. Notice that the JOB_DATA component name is
hard coded in the SQL.
SELECT PORTAL_OBJNAME , PORTAL_URI_SEG2
FROM
PSPRSMDEFN
WHERE PORTAL_NAME = 'EMPLOYEE'
AND PORTAL_URI_SEG2 like'JOB_DATA' -- THIS IS THE COMPONENT NAME
Step 2.) Use the Online Portal Page to look this portal object name.
Navigate to: PeopleTools | Portal |View Menu Item Detail
Then enter in the PORTAL_OBJNAME found above in the search record and
the page will show you where the navigation is.
Force a CREF Open in a New Window
Here is a quick tip to make a portal Content Reference (CREF) open in
a new window.
This might be used for linking to an external or intranet site that is
not part of Peopletools.
You just need to add a Content Reference Attribute of "NAVNEWWIN" = true
This is a script to show you how to insert a role from the back end.
INSERT INTO
PSROLEUSER (ROLEUSER, ROLENAME, DYNAMIC_SW)
VALUES ('AKSHATA','PeopleTools','N')
Find Unused Permission Lists
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 ;