EBS access Audit and Security?

In this forum Oracle Applications DBA's, System Administrators & Developers can share their knowledge/issues.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

EBS access Audit and Security?

Post by admin »

How to audit/list failed/unsuccessful login attempts for Standalone E-Business Suite R12.

Setup done:

Profile Option related to sign-on Auditing in R12.
a) Sign-On:Audit Level -> allows you to select a level at which to audit users who sign on to Oracle Applications.
You can set this profile option to None, User, Responsibility, and Form.

i) None means do not audit any users who sign on to Oracle Applications.
ii) Auditing at the User level tracks: who signs on to your system, the times users log on and off
iii) Auditing at the Responsibility level performs the User level audit functions + the responsibilities users choose + how much time users spend using each responsibility
iv) Auditing at the Form level performs the Responsibility level audit functions + the forms users choose + how long users spend using each form + System Administrator visible, updatable at all levels.

b) Sign-On:Notification Set this to Yes to enable Auditing

Available Concurrent Requests :
a) Signon Audit Unsuccessful Logins- Use this report to view who unsuccessfully attempted to sign on to Oracle Applications as another user. An unsuccessful login occurs when a user enters a correct username but an incorrect password. You can generate Signon Audit Unsuccessful Logins Reports for any users, regardless of whom you are auditing.

b) Signon Audit Users – Use this report to view who signs on and for how long

Wrong attempts for today,

SELECT B.USER_NAME, count(*)
FROM applsys.FND_UNSUCCESSFUL_LOGINS U, applsys.FND_USER B
WHERE U.USER_ID = B.USER_ID
--AND B.USER_NAME = :USER_NAME
AND TRUNC(U.ATTEMPT_TIME) = TRUNC(SYSDATE)
group by b.user_name;

Set Profile to lock if unsuccessful login attempts,

Signon Password Failure Limit = 3
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest