| use aud$ table [message #354124] |
Thu, 16 October 2008 08:36  |
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 #354266 is a reply to message #354127] |
Fri, 17 October 2008 04:38  |
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 #355471 is a reply to message #354269] |
Fri, 24 October 2008 05:11 |
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 #359665 is a reply to message #355476] |
Mon, 17 November 2008 23:09 |
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 #359779 is a reply to message #359712] |
Tue, 18 November 2008 03:35 |
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 #360001 is a reply to message #359792] |
Wed, 19 November 2008 03:15 |
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 #360453 is a reply to message #360008] |
Fri, 21 November 2008 01:22 |
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 #360526 is a reply to message #360520] |
Fri, 21 November 2008 04:50 |
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 #360562 is a reply to message #360544] |
Fri, 21 November 2008 06:45 |
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 #360659 is a reply to message #360567] |
Fri, 21 November 2008 22:32 |
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 |
 |
Michel Cadot
Messages: 68699
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
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
