1 Reply Latest reply: Dec 16, 2010 11:15 AM by 824346 RSS

    Peoplesoft on sql server 2005

    718721
      Hello,

      I need to do an auditory on a PeopleSoft architecture running on a sql server 2005 database, which table are usefull too get acounts' date of creation, profile assigned, etc.?
        • 1. Re: Peoplesoft on sql server 2005
          824346
          PSACCESSLOG - Access Log

          PSPRSMPERM: Portal Structure Permissions.

          PSAUTHITEM: Page Permissions. This table stores the information about the page level access for a permission list.

          PSROLECLASS: 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.

          PSOPRCLS: Users/Operator and Perm list mapping Table. This table stores information about PeopleSoft users and the permission lists attached to those users.
          A User gets these permission lists indirectly through the roles which are attached to the user


          Let me know if you have any questions.
          Regards,
          RK