From dgoulet@vicr.com Tue, 07 Aug 2001 10:02:56 -0700 From: dgoulet@vicr.com Date: Tue, 07 Aug 2001 10:02:56 -0700 Subject: Re:Help needed Message-ID: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="Boundary..31565.1077462905.multipart/mixed" --Boundary..31565.1077462905.multipart/mixed Content-Type: text/plain Content-Transfer-Encoding: 7bit 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." 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 <> Help needed

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>>

Deewaker G.V..vcf --Boundary..31565.1077462905.multipart/mixed Content-Type: application/octet-stream; name="msg19723" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="msg19723" Content-Description: "" --Boundary..31565.1077462905.multipart/mixed--