nirvairghuman
asked on
How can I check user login times in 11g
Hi guys, which view I can use to check a particular user's login and logoff times.
ASKER
Our auditing is on,
If you are auditing the session then you should be able to query the audit tables.
On mobile and cannot search for examples but there should be examples in the online docs on querying the audit trail.
On mobile and cannot search for examples but there should be examples in the online docs on querying the audit trail.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
schwertner:
They have already enable AUDIT then why we need to maintain system level trigger and user defined audit table?
I accept system audit table wont maintain IP address. but you have used that. I didnt think IP will be useful in all the cases.
All the application will maintain application level audit that is another context.
They have already enable AUDIT then why we need to maintain system level trigger and user defined audit table?
I accept system audit table wont maintain IP address. but you have used that. I didnt think IP will be useful in all the cases.
All the application will maintain application level audit that is another context.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There might be other options that I do not know about.