MIN_SRV_SEC_VW (SQL View)	Index Back
Service Opration Security Service Opration Security view

MIN_SRV_SEC_VW

(SQL View)

Service Opration Security

Service Opration Security view

SELECT DISTINCT D.OPRID , B.CLASSID , B.IB_OPERATIONNAME , A.VERSIONNAME , A.ACTIVE_FLAG , B.AUTHORIZEDACTIONS FROM PSOPRVERDFN A , PSAUTHWS B , PSROLEUSER E , PSROLECLASS C , PSOPRDEFN D WHERE A.IB_OPERATIONNAME = B.IB_OPERATIONNAME AND E.ROLEUSER = D.OPRID AND B.CLASSID = C.CLASSID AND E.ROLENAME = C.ROLENAME AND B.AUTHORIZEDACTIONS = 4

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 CLASSID Character(30) VARCHAR2(30) NOT NULL The name of the class (see PSCLASSDEFN).

3 IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).

4 VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version

5 ACTIVE_FLAG Character(1) VARCHAR2(1) NOT NULL Active Flag
A=Active
I=Inactive

6 AUTHORIZEDACTIONS Number(10,0) DECIMAL(10) NOT NULL Authorized Actions for Panels

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	CLASSID	Character(30)	VARCHAR2(30) NOT NULL	The name of the class (see PSCLASSDEFN).
3	IB_OPERATIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation (see PSOPERATION).
4	VERSIONNAME	Character(30)	VARCHAR2(30) NOT NULL	Service Operation Version
5	ACTIVE_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Active Flag A=Active I=Inactive
6	AUTHORIZEDACTIONS	Number(10,0)	DECIMAL(10) NOT NULL	Authorized Actions for Panels