PSROLEGRANTORVW

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 NameField TypeColumn TypeDescription
ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).
GRANTROLENAMECharacter(30)VARCHAR2(30) NOT NULLCan Grant Role

Prompt Table: PSROLEDEFN

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19