Home » RDBMS Server » Security » Monitor user's daily activity (unix 10g)
Monitor user's daily activity [message #279764] Sat, 10 November 2007 03:34 Go to next message
alzuma
Messages: 46
Registered: July 2006
Location: CA
Member
Dear,

Can i get all the commands that an oracle user executed a certain day?

Regards

[RENAMED by LF: the old title was "usre monitor"]

[Updated on: Sat, 10 November 2007 03:37] by Moderator

Report message to a moderator

Re: Monitor user's daily activity [message #279767 is a reply to message #279764] Sat, 10 November 2007 03:38 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is possible, if you enable auditing.
Re: Monitor user's daily activity [message #279784 is a reply to message #279764] Sat, 10 November 2007 04:05 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can also use LogMiner to mine the (archived) redo logs for all statements but SELECT.

Regards
Michel
Previous Topic: Oracle installation groups and permissions
Next Topic: Password
Goto Forum:
  


Current Time: Fri Mar 29 00:39:39 CDT 2024