EM_ROLEUSRDM_VW

(SQL View)
 Index Back

User Roles for Dist User Maint

User Roles for Distributed User Maintanence to handle the Can Grant Role Security

SELECT DISTINCT A.ROLEUSER , A.ROLENAME , B.EM_ROLENAME FROM PSROLEUSER A , PS_EM_ROLE_CONFIG B WHERE A.ROLENAME = B.EM_ROLENAME AND B.EM_ROLETYPE <> '35'

  • Parent record: PSOPRDEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 GRANTROLENAME Character(30) VARCHAR2(30) NOT NULL Can Grant Role

    Prompt Table: %EDITTABLE

    3 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).