Re:Help needed

From: <dgoulet_at_vicr.com>
Date: Tue, 07 Aug 2001 10:02:56 -0700
Message-ID: <F001.00363075.20010807101350@fatcity.com>

There are two things you can do:

turn Oracle auditing on for ddl statements to see who's doing them.
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." <Deewaker_at_baazee.com>
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>

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



</BODY>
</HTML>

Deewaker G.V..vcf

Received on Tue Aug 07 2001 - 12:02:56 CDT