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 Name Field Type Column Type Description
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19