| dba problem [message #521915] |
Sun, 04 September 2011 02:47  |
 |
shashank_kurasrediffmail
Messages: 63
Registered: July 2011
Location: hyderabad
|
Member |
|
|
hi all
I have a problem some user modified the objects and now objects became invalid .
How to trace the ip adress and operating system username and service ip who modified the objects?
please help me thanks for all inadvance.
[Updated on: Sun, 04 September 2011 03:10] Report message to a moderator |
|
|
|
| Re: dba problem [message #521916 is a reply to message #521915] |
Sun, 04 September 2011 03:47  |
John Watson
Messages: 8931
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
If you enable database auditing (look up the AUDIT command) you can trap this information.
By the way, are you really using release 8.0? It dates back to 1997.
[update: typo]
[Updated on: Sun, 04 September 2011 03:48] Report message to a moderator |
|
|
|
| Re: dba problem [message #522118 is a reply to message #521916] |
Tue, 06 September 2011 12:50 |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
John Watson wrote on Sun, 04 September 2011 04:47
By the way, are you really using release 8.0? It dates back to 1997.
[update: typo
Was AUDIT even available in 8.0? That is not even 8i.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
