There are two things you can do:
1) turn Oracle auditing on for ddl statements to see who's doing them.
2) if you know the username where things are being messed up, you could
revoke the create session privilege & find out who screams.
I'd also look at that table and see who has index privileges on it or if anyone
has create, delete, or alter any index privileges. You might check as to who
has the dba role. Revoking it may bring the culprit out of hiding.
Dick Goulet
____________________Reply Separator____________________
Author: "Deewaker G.V." <[EMAIL PROTECTED]>
Date: 8/7/2001 12:00 AM
HI DBA Guru's
It has been a painful process for me everytime when I change the password of
the user in ORACLE.. The reason is simple.... Some one is trying to play
with the tables and change the INDEXS... delete the synonyn... and so on...
I just want to know how do I come to know either or all of this..
The pc name who was connected.
The time when he/she executed the process
What was the command given to execute the same..
Pls... Guruji's help me...
with warm regards,
Deewaker G. V.
Baazee.com India Pvt. Ltd.
*: 4611323 Extn: 216
Fax : 4611324
<<Deewaker G.V..vcf>>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12">
<TITLE>Help needed </TITLE>
</HEAD>
<BODY>
<P><FONT COLOR="#0000FF" FACE="Arial Narrow">HI DBA Guru's</FONT>
</P>
<P><FONT COLOR="#0000FF" FACE="Arial Narrow">It has been a painful process for
me everytime when I change the password of the user in ORACLE.. The reason is
simple.... Some one is trying to play with the tables and change the INDEXS...
delete the synonyn... and so on... I just want to know how do I come to know
either or all of this..</FONT></P>
<P><FONT COLOR="#0000FF" FACE="Arial Narrow">The pc name who was
connected.</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial Narrow">The time when he/she executed the
process</FONT>
<BR><FONT COLOR="#0000FF" FACE="Arial Narrow">What was the command given to
execute the same..</FONT>
</P>
<P><FONT COLOR="#0000FF" FACE="Arial Narrow">Pls... Guruji's help me...</FONT>
</P>
<P><FONT COLOR="#0000FF" FACE="Book Antiqua">with warm regards,</FONT>
</P>
<P><FONT COLOR="#0000FF" FACE="Book Antiqua">Deewaker G. V.</FONT>
</P>
<P><FONT COLOR="#0000FF" FACE="Book Antiqua">Baazee.com India Pvt. Ltd.</FONT>
<BR><FONT COLOR="#0000FF" FACE="Wingdings">(</FONT><FONT COLOR="#0000FF"
FACE="Book Antiqua">: 4611323 Extn: 216</FONT>
<BR><FONT COLOR="#0000FF" FACE="Book Antiqua">Fax : 4611324</FONT>
</P>
<P><FONT FACE="Arial" SIZE=2 COLOR="#000000"> <<Deewaker G.V..vcf>>
</FONT>
</P>
</BODY>
</HTML>
Deewaker G.V..vcf
