Home » RDBMS Server » Security » use aud$ table (oracle 9i windows server 2003)  () 1 Vote
use aud$ table [message #354124] Thu, 16 October 2008 08:36 Go to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member
dear
i have activate the utility of user audit by using Audit_trail = true, different activities from user is shown but the problem is that WHENEVER A USER LOGIN THAN TABLE SHOW IT BUT LATER I CAN'T FIND THE LOGON TIME IN THE AUD$ TABLE,
i can want only logon and logoff time of users only ,how can i do this?

Thanks

Best Regard

Azhar Masood
Re: use aud$ table [message #354127 is a reply to message #354124] Thu, 16 October 2008 08:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"audit session;"

And don't use sys.aud$ use dba_audit_trail.

Regards
Michel
Re: use aud$ table [message #354266 is a reply to message #354127] Fri, 17 October 2008 04:38 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member
dear
I want just make a report for the users login and logoff time,
i cant find the logon time in dba_audit_trail and other views or table,please guide me how can i make this report

best regard

Azhar Masood
Re: use aud$ table [message #354269 is a reply to message #354127] Fri, 17 October 2008 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Thu, 16 October 2008 15:48
"audit session;"

And don't use sys.aud$ use dba_audit_trail.

Regards
Michel


Have a look at the statement I mentioned in SQL Reference.


Re: use aud$ table [message #355471 is a reply to message #354269] Fri, 24 October 2008 05:11 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member
dear all,

as we r using
Oracle9i
win server 2003

we r using oracle as backend database while front end is Sage ACCPAC erp software, As i log in accpac than i see in oem session atleast three user login and if i open more module than in oracle more user show,in this environment how can i use session auditing (to get user login ,logoff information)?. can any one tell me the solution that he is working like this environment.


Best Regard,

Azhar Masood
Re: use aud$ table [message #355476 is a reply to message #355471] Fri, 24 October 2008 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Fri, 17 October 2008 11:48
Michel Cadot wrote on Thu, 16 October 2008 15:48
"audit session;"

And don't use sys.aud$ use dba_audit_trail.

Regards
Michel


Have a look at the statement I mentioned in SQL Reference.


Re: use aud$ table [message #359665 is a reply to message #355476] Mon, 17 November 2008 23:09 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member

i have enabled the audit_session but from any wiew i couldn't
see the logon time of a user,when a user logon then user logon time show but when he logoff then his logon time not shown.

please guide me that how can i make a report for user logon time
period in detail.

Best Regards

Azhar Masood
Re: use aud$ table [message #359712 is a reply to message #359665] Tue, 18 November 2008 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As you still don't show us what you did, we can't help telling you what is wrong.

Regards
Michel
Re: use aud$ table [message #359779 is a reply to message #359712] Tue, 18 November 2008 03:35 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member
ok
first of all i run the script cataudit.sql as sys user,
then enable the parameter audit_trail = true
and then run the command dba_audit_session by user...

and now i can see different types of audited records in $aud table and other wiews especialy logoff time and total session physical and logical reads etc. but the problem is that the user login time disapear when user log off.and i want only logon and logoff time of a user.

Best regards


Re: use aud$ table [message #359792 is a reply to message #359779] Tue, 18 November 2008 04:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
then run the command dba_audit_session by user...

This command does not exist.

Regards
Michel
Re: use aud$ table [message #360001 is a reply to message #359792] Wed, 19 November 2008 03:15 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member


i am very thank ful to you that inform me that dba_audit_session
type statment not a command exist.(i was meant to show that i have activate the session auditing by the statement)

however if you know any article etc which help me to produce user login time period Report,plz inform me.

regard
Re: use aud$ table [message #360008 is a reply to message #360001] Wed, 19 November 2008 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 18 November 2008 08:10
As you still don't show us what you did, we can't help telling you what is wrong.

Regards
Michel


Re: use aud$ table [message #360453 is a reply to message #360008] Fri, 21 November 2008 01:22 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member
i am very thank ful to you that inform me that dba_audit_session
type statment not a command exist.(i was meant to show that i have activate the session auditing by the statement)

however if you know any article etc which help me to produce user login time period Report,plz inform me.

regard
Re: use aud$ table [message #360473 is a reply to message #360453] Fri, 21 November 2008 02:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Wed, 19 November 2008 10:37
Michel Cadot wrote on Tue, 18 November 2008 08:10
As you still don't show us what you did, we can't help telling you what is wrong.

Regards
Michel




Re: use aud$ table [message #360497 is a reply to message #360473] Fri, 21 November 2008 03:13 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member
i think you are a expert in copy paste command.
Re: use aud$ table [message #360520 is a reply to message #360497] Fri, 21 November 2008 04:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you can't read.
So the best way to make you understand is to repeat.

Regards
Michel
Re: use aud$ table [message #360526 is a reply to message #360520] Fri, 21 November 2008 04:50 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member

this is your thinking ,i dont think so.

anyone have provided you information as he think/know about concern matter,if u requird more information to solve the problem then you may point out reqiured information, (from different angles),
the easiest way to copy paste previouse answer but not a
benificient practice either side, the better way is that u dont reply.

with best wishes

Azhar Masood
Re: use aud$ table [message #360532 is a reply to message #360526] Fri, 21 November 2008 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does "copy and paste what you did" clear enough?

Regards
Michel
Re: use aud$ table [message #360540 is a reply to message #360532] Fri, 21 November 2008 05:30 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member


I think u haven't sufficient knowledge to solve the problem ,
your behaviour doesn't match to yor status.this is bitter for u but fact. Shocked
Re: use aud$ table [message #360544 is a reply to message #360540] Fri, 21 November 2008 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you think, I have no problem if you can't solve yours.

Regards
Michel
Re: use aud$ table [message #360562 is a reply to message #360544] Fri, 21 November 2008 06:45 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member

every problem has a solution in the world,if u dont know so what . when i receive the solutiion then i must inform you.

but the point is that what r you doing here?
Re: use aud$ table [message #360567 is a reply to message #360562] Fri, 21 November 2008 07:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I answer to the question when people give sufficient information to give an accurate and appropriate answer.
Now let me ask, what are you doing here if you don't want people to help you giving them the data they request?
Note that I'm the only one to answer to your topic. Nothing raise in your mind?
Maybe I'm the only one which is stubborn enough trying to help you when you refuse to.

Regards
Michel
Re: use aud$ table [message #360659 is a reply to message #360567] Fri, 21 November 2008 22:32 Go to previous messageGo to next message
azhar masood
Messages: 15
Registered: September 2008
Location: Pakistan
Junior Member

i have provide you information as i think best for this solution.
if you think more information you may point out then i do.
But you dont feel this and countinue the practice a copy paste of previous answer. you may use copy paste for refrence to an other Q&A, but same in a Q&A you waste your time.

Azhar Masood
Re: use aud$ table [message #360666 is a reply to message #360659] Sat, 22 November 2008 00:21 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Does "copy and paste what you did" clear enough?

If you don't understand this what can I say?

Regards
Michel
Previous Topic: OID issue
Next Topic: Problem on Job
Goto Forum:
  


Current Time: Thu Mar 28 16:30:38 CDT 2024