RC_LIB_ROLE_VW (SQL View)	Index Back
Library Role Security View This view returns a list of Librarys that have secured roles along with the users that have that role and therefore the users have security to the library.

RC_LIB_ROLE_VW

(SQL View)

Library Role Security View

This view returns a list of Librarys that have secured roles along with the users that have that role and therefore the users have security to the library.

SELECT A.ROLEUSER , A.ROLENAME , B.SETID , B.LIBRARY_ID FROM PSROLEMEMBER A , PS_RC_SOLN_LIBSECR B WHERE A.ROLENAME = B.ROLENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User

2 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

3 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

4 LIBRARY_ID Character(5) VARCHAR2(5) NOT NULL Solution Library ID or Troubleshooting Guide ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ROLEUSER	Character(30)	VARCHAR2(30) NOT NULL	Role User
2	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
3	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
4	LIBRARY_ID	Character(5)	VARCHAR2(5) NOT NULL	Solution Library ID or Troubleshooting Guide ID