AboutPeter Choi Expertise I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with
10 years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and
8.8), Oracle RDBMS (7.3 - 10g) on various Unix and Windows platforms, and some Oracle Application Server (9i/10g). I also have experience with the configuration and administration of BEA`s Tuxedo
and WebLogic for PeopleSoft 8.x.
Expert: Peter Choi Date: 11/8/2007 Subject: HISTORY ON USER ACCESS
Question WHAT TABLES/RECORDS IN PEOPLESOFT CAN I VIEW PEOPLES ACCESS HISTORY. FOR EXAMPLE IF THEY HAD ACCESS TO CERTAIN PERMISSIONS BEFORE AFTER A CHANGE HAS BEEN MADE.
THANKS
Answer Hi Margret,
PeopleSoft does not audit changes to a users permission. These can be enabled via third party (e.g. Creating your own Oracel triggers or external vendor) or through customization of PeopleSoft (using PeopleTools).
PeopleSoft does have application audits that are used to track who made what changes to the application. Typcially the tables begin with AUDIT_ rather than the usual PS_
