HI,
Kindly let know if there is any query with which I can see who was already logged in and logged off a day before, this is to know if some one deletes a row yest and If i want to know who did login and what the query given.
Thank you for the help
Printable View
HI,
Kindly let know if there is any query with which I can see who was already logged in and logged off a day before, this is to know if some one deletes a row yest and If i want to know who did login and what the query given.
Thank you for the help
v$session - column : login_time - will tell you when the user logged in.
If your using 8i or above logminer is the way to go to get what your looking for.
Auditing. Check the Concepts/Administration manuals about this.