| User Locked [message #486995] |
Tue, 21 December 2010 23:56  |
soft_doctor
Messages: 33
Registered: May 2010
|
Member |
|
|
Dear Team,
Greetings of the day.
We have the database user called c88888 and is locked yesterday. I came to this with the following query.
select * from dba_users where username like 'C88888';
Due to invalid password the user was locked. Can we track who hit the database with the wrong password?
Please help me soon. Thank you.
Regards,
Chandu
|
|
|
|
|
|
| Re: User Locked [message #487003 is a reply to message #486997] |
Wed, 22 December 2010 00:31  |
soft_doctor
Messages: 33
Registered: May 2010
|
Member |
|
|
We have the following configuration
SQL> sho parameter audit
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /home/oracle/app/oracle/admin/amspqa70/adump
amspqa70/adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB
|
|
|
|
| Re: User Locked [message #487004 is a reply to message #487003] |
Wed, 22 December 2010 00:35 |
soft_doctor
Messages: 33
Registered: May 2010
|
Member |
|
|
Aligned Properly..
SQL> sho parameter audit
NAME TYPE VALUE
------------- --------- -----------
audit_file_dest string /home/oracle/app/oracle/admin/amspqa70/adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB
|
|
|
|
|
|
| Re: User Locked [message #487047 is a reply to message #487021] |
Wed, 22 December 2010 03:36 |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
In 11g, CREATE SESSION should be audited by default:
select PRIVILEGE, SUCCESS,FAILURE from dba_priv_audit_opts;
(I suppose it might not be if you upgraded from 10g, and didn't implement the new security recommendations.)
So simply select from your audit trail, something like
select os_username,terminal,username from dba_audit_trail where priv_used='CREATE SESSION';
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
