Home » RDBMS Server » Security » Oracle Database (Oracle Database 9.2.0 64 bit, SunSolaris)
Oracle Database [message #362139] Mon, 01 December 2008 03:19 Go to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi

I have enabled the audit for creating the session either successful or faliure & using the following sql command to check the no of time failure or success

============================================================
select count(*),username,terminal,to_char(timestamp,'DD-MON-YYYY'),returncode
from dba_audit_session where username='TEST'
group by username,terminal,to_char(timestamp,'DD-MON-YYYY'),returncode
=============================================================

ON Success it showing the count 1 which is Ok But on every failure it is counting 2 while i am trying to connect from oracle client.

Can u suggest & Advise why it is so


Thanks
TM

Report message to a moderator

Re: Oracle Database [message #362156 is a reply to message #362139] Mon, 01 December 2008 03:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Post the content of these 2 rows.

Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: Oracle Database [message #362180 is a reply to message #362139] Mon, 01 December 2008 04:51 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Hi


-----------------------------------------------------------------
COUNT(*) USERNAME TERMINAL TO_CHAR(TIMESTA RETURNCODE
--------- ---------- --------------- --------------- ----------
25 TEST Windows NT PC 01-DEC-2008 0
20 TEST Windows NT PC 01-DEC-2008 1017
-----------------------------------------------------------------


Thanks

Report message to a moderator

Re: Oracle Database [message #362200 is a reply to message #362180] Mon, 01 December 2008 05:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
ON Success it showing the count 1 which is Ok But on every failure it is counting 2 while i am trying to connect from oracle client.

Post accordingly with what you say.

Regards
Michel

Report message to a moderator

Re: Oracle Database [message #362207 is a reply to message #362200] Mon, 01 December 2008 05:45 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Whenever login fail then it count 2 instead of 1 while try to connect from oracle client

Report message to a moderator

Re: Oracle Database [message #362229 is a reply to message #362207] Mon, 01 December 2008 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
I don't see what you claim from what you posted.

Regards
Michel

Report message to a moderator

Re: Oracle Database [message #362336 is a reply to message #362229] Mon, 01 December 2008 21:22 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
I m simpliy saying after one login failure attempt it consider it two login failure.

However it should be one if i have attempt once


hope this time you got it

Thanks

Report message to a moderator

Re: Oracle Database [message #362342 is a reply to message #362336] Mon, 01 December 2008 22:29 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Now showing the output what i have explaine. Failure is once but it showing 2. however success is OK


-----------------------------------------------------------------
COUNT(*) USERNAME TERMINAL TO_CHAR(TIMESTA RETURNCODE
--------- ---------- --------------- --------------- ----------
1 TEST Windows NT PC 01-DEC-2008 0
2 TEST Windows NT PC 01-DEC-2008 1017
-----------------------------------------------------------------

Report message to a moderator

Re: Oracle Database [message #362363 is a reply to message #362342] Tue, 02 December 2008 00:55 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Kindly suggest

Report message to a moderator

Re: Oracle Database [message #362366 is a reply to message #362363] Tue, 02 December 2008 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
1/ You didn't follow the guidelines
2/ You didn't post what I requested:
Quote:
Post the content of these 2 rows.

I didn't ask the result of your query but THESE TWO ROWS.
In addition, post time with date.

Regards
Michel

Report message to a moderator

Re: Oracle Database [message #362368 is a reply to message #362366] Tue, 02 December 2008 01:06 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Sorry m

i m not able to understand
which two rows your are talking about

Kindly explain

Report message to a moderator

Re: Oracle Database [message #362369 is a reply to message #362368] Tue, 02 December 2008 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
2 TEST Windows NT PC 01-DEC-2008 1017

These 2 ones you counted.

Regards
Michel

Report message to a moderator

Re: Oracle Database [message #362383 is a reply to message #362369] Tue, 02 December 2008 01:59 Go to previous messageGo to next message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
It not showing the two rows instead it add the count(*) by 2 number like on first failure count column value is 2 and on second failure count column values is 4 so on..... in the same date

Report message to a moderator

Re: Oracle Database [message #362389 is a reply to message #362383] Tue, 02 December 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Without this information I can't help.

Regards
Michel

Report message to a moderator

Re: Oracle Database [message #362408 is a reply to message #362389] Tue, 02 December 2008 03:53 Go to previous message
tkmittal1
Messages: 143
Registered: May 2007
Location: Delhi
Senior Member
Thanks

Report message to a moderator

Previous Topic: Grant privilege to "user b" for object in schema "user a"
Next Topic: ORA-01031: insufficient privileges
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 30 17:03:16 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.