EM_VNDR_USR_PRT (SQL View)	Index Back
Local Admin Auth. Users MarketPay Security This SQL view will limit access by a local administrator only to user profiles that share his/her supplier permissions. Since it is returning a list of User OPRIDs, the SQL view must use the Local Administrator's ROWSECCLASS. Caveat: The Local Administrator's ROWSECCLASS must contain a value equal to his/her USERID. This SQL View is used as the controlling record in the grid of the Seller Security Inquiry Page. This is the MarketPay version of a Search Record.

EM_VNDR_USR_PRT

(SQL View)

Local Admin Auth. Users

MarketPay Security This SQL view will limit access by a local administrator only to user profiles that share his/her supplier permissions. Since it is returning a list of User OPRIDs, the SQL view must use the Local Administrator's ROWSECCLASS. Caveat: The Local Administrator's ROWSECCLASS must contain a value equal to his/her USERID. This SQL View is used as the controlling record in the grid of the Seller Security Inquiry Page. This is the MarketPay version of a Search Record.

SELECT DISTINCT A.OPRID ,C.OPRDEFNDESC FROM PS_VENDOR_USER A , PSOPRDEFN C , PSROLEUSER D , PS_EM_ROLE_CONFIG E WHERE A.OPRID = C.OPRID AND A.OPRID = D.ROLEUSER AND D.ROLENAME = E.EM_ROLENAME AND E.EM_ROLETYPE IN ('25', '30')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

2 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	USERID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID
2	OPRDEFNDESC	Character(30)	VARCHAR2(30) NOT NULL	Description field for a user