PSPTADSRTRWP_VW

index back

Permission of copy/comp access

Permission lists that have copy/compare permissions for ADS datasets
SELECT ASEC.CLASSID , RU.ROLEUSER , ASEC.PTADSACCESS FROM PSPTSCRTY_ADS_P ASEC , PSROLEUSER RU , PSROLECLASS RC WHERE ASEC.CLASSID= RC.CLASSID AND RU.ROLENAME= RC.ROLENAME AND ASEC.PTADSACCESS <> 'NO' ORDER BY ASEC.CLASSID, RU.ROLEUSER, ASEC.PTADSACCESS

PeopleSoft Field Name Field Type Column Type Description
CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).
ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
PTADSACCESS Character(4) VARCHAR2(4) NOT NULL Access Code
FULL=Full Access
NO=No Access
READ=Read Only
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20