RC_LIB_ROLE_VW(SQL View) |
Index Back |
---|---|
Library Role Security ViewThis 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 | Character(30) | VARCHAR2(30) NOT NULL | Role User | |
2 | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). | |
3 | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. | |
4 | Character(5) | VARCHAR2(5) NOT NULL | Solution Library ID or Troubleshooting Guide ID |