PeopleSoft Security Tables

Below are few tables that are involved in PeopleSoft Security:-

• PSROLECLASS: It is Role Classes table. A many to many relationship table between Roles and Permission Lists.

• PSROLEDEFN: This table stores information about PeopleSoft Role definitions. Users get permissions to PeopleSoft objects through Roles, which are assigned Permission Lists.

• PSROLEUSER: This table stores information about the Users in PeopleSoft and the roles assigned to them.

• PSCLASSDEFN: Permissions List definitions table. Permission list name can be found under Field Name CLASSID.

• PSOPRDEFN: Users/Operator definition table. This table stores information about PeopleSoft users. This is the core table for User Profile Manager.

*******************************Thanks For the Visit **************************

FFreshers / Students:-

     For making career in PeopleSoft and learn PeopleSoft Technical / DBA / Functional Please visit www.orainstall.com