index back

Roles That Can Grant - View

A view to extract "Grantor Roles" and Roles that van be granted by the "Grantor Roles".
SELECT grantrolename , rolename FROM PSROLECANGRANT

PeopleSoft Field Name Field Type Column Type Description
ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
GRANTROLENAME Character(30) VARCHAR2(30) NOT NULL Can Grant Role

Prompt Table: PSROLEDEFN

index back (c)David Kurtz 2020, PeopleTools 8.58
PTRef generated on 21-DEC-20