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 2019, PeopleTools 8.54
PTRef generated on 09-JUN-19