RSEC_OBJREL_VW (SQL View)	Index Back
Related Security Object Related Security Objects are stored in this table.

RSEC_OBJREL_VW

(SQL View)

Related Security Object

Related Security Objects are stored in this table.

SELECT DISTINCT A.RSEC_OBJECT_ID , B2.DESCR , B1.DESCR , B1.RSEC_OBJECT_TYPE , B1.RSEC_SHOW_IN_WIZ , A.RSEC_REL_OBJ_ID , B2.RSEC_OBJECT_TYPE , B2.RSEC_SHOW_IN_WIZ FROM PS_RSEC_OBJECT_REL A , PS_RSEC_OBJECTDEFN B1 , PS_RSEC_OBJECTDEFN B2 WHERE A.RSEC_REL_OBJ_ID = B2.RSEC_OBJECT_ID AND A.RSEC_OBJECT_ID = B1.RSEC_OBJECT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RSEC_OBJECT_ID Character(30) VARCHAR2(30) NOT NULL Security Object ID used for defining application security objects.

2 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 RSEC_OBJECT_TYPE Character(4) VARCHAR2(4) NOT NULL Security object type of membership or view list translate field. The field value on the security object definition determines if the security object is considered as a membership or view object.
0001=Membership
0002=View Privilege

5 RSEC_SHOW_IN_WIZ Character(1) VARCHAR2(1) NOT NULL The field is used on a security object to determine if adding single membership or view privilege domains for a security key is allowed.

6 RSEC_REL_OBJ_ID Character(30) VARCHAR2(30) NOT NULL Related security object ID field is captured using this field definition.
Prompt Table: %EDITTABLE2

7 RSEC_REL_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL Related security object type of application security.
0001=Membership
0002=View Privilege

8 RSEC_SHOW_IN_WIZ2 Character(1) VARCHAR2(1) NOT NULL The field is used on a security object to determine if adding single membership or view privilege domains for a security key is allowed.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RSEC_OBJECT_ID	Character(30)	VARCHAR2(30) NOT NULL	Security Object ID used for defining application security objects.
2	DESCR2	Character(30)	VARCHAR2(30) NOT NULL	Descr2
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	RSEC_OBJECT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Security object type of membership or view list translate field. The field value on the security object definition determines if the security object is considered as a membership or view object. 0001=Membership 0002=View Privilege
5	RSEC_SHOW_IN_WIZ	Character(1)	VARCHAR2(1) NOT NULL	The field is used on a security object to determine if adding single membership or view privilege domains for a security key is allowed.
6	RSEC_REL_OBJ_ID	Character(30)	VARCHAR2(30) NOT NULL	Related security object ID field is captured using this field definition. Prompt Table: %EDITTABLE2
7	RSEC_REL_OBJ_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Related security object type of application security. 0001=Membership 0002=View Privilege
8	RSEC_SHOW_IN_WIZ2	Character(1)	VARCHAR2(1) NOT NULL	The field is used on a security object to determine if adding single membership or view privilege domains for a security key is allowed.