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: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It is possible, if you enable auditing.

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can also use LogMiner to mine the (archived) redo logs for all statements but SELECT.

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 07:35:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.