TL_ROLE_VW

(SQL View)
 Index Back

Portal Details

Get component, page, permission list, roles details using Portal Name and Portal Object Name

SELECT POR.PORTAL_NAME , POR.PORTAL_OBJNAME , POR.PORTAL_NAME , AUTH.MENUNAME , AUTH.BARNAME , AUTH.BARITEMNAME , RCL.CLASSID , RCL.ROLENAME , RDFN.DESCR FROM PSPRSMDEFN POR , PSAUTHITEM AUTH , PSROLECLASS RCL , PSROLEDEFN RDFN WHERE POR.PORTAL_URI_SEG1 = AUTH.MENUNAME AND POR.PORTAL_URI_SEG2 = AUTH.BARITEMNAME AND POR.PORTAL_REFTYPE = 'C' AND AUTH.CLASSID = RCL.CLASSID AND RCL.ROLENAME = RDFN.ROLENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).
2 PORTAL_OBJNAME Character(30) VARCHAR2(30) NOT NULL Portal Object Name
3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label
4 MENUNAME Character(30) VARCHAR2(30) NOT NULL Menu Name (see PSMENUDEFN).
5 BARNAME Character(30) VARCHAR2(30) NOT NULL Menu Bar Name
6 ITEMNAME Character(30) VARCHAR2(30) NOT NULL Item Name
7 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
8 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
9 DESCR Character(30) VARCHAR2(30) NOT NULL Description