Link to home
Start Free TrialLog in
Avatar of nirvairghuman
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.
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

If you don't have auditing turned on I believe you will need a system trigger to track this.

There might be other options that I do not know about.
Avatar of nirvairghuman

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.
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial