BNFD - Your DBA NoteBook On The Net!!!

Thursday, June 26, 2008

Apps Auditing

Oracle application user level auditing is possible -

User level
Responsibility level
Form level

All user signons, responsibility selections, and form accesses will be logged toAPPLSYS.FND_LOGINSAPPLSYS.FND_LOGIN_RESPONSIBILITIES.APPLSYS.FND_LOGIN_RESP_FORMSAPPS AUDITING – END USER ACCESS Unsuccessful Logins Unsuccessful password attempts are automatically recorded in the APPLSYS.FND_UNSUCCESSFUL_LOGINS and ICX.ICX_FAILURESConcurrent Requests All concurrent requests are recorded in the FND_CONCURRENT_REQUESTS table. There is no configuration required. Based upon the level of Sign Auditing selected the System capture all or some of the following information.• The users who sign on to the system• The Sign in and Sign Out times• Responsiblities they choose• The forms they use• Duration of using the form or responsibility• Terminals used for sign on.