AMM_MSG_SECVW

index back

Msg Monitor Message Sec View

Security view that lists message names an operator has read or write access for in the Message Monitor.
SELECT DISTINCT A.OPRID , C.MSGNAME FROM PSOPRCLS A , PSAUTHCHNLMON B , PSMSGDEFN C WHERE A.OPRCLASS = B.CLASSID AND B.CHNLNAME = C.CHNLNAME

PeopleSoft Field NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
MSGNAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19