If on oracle 8i, you may also consider database triggers to prevent ddl stmts, userwise.
rgds
amar
-----Original Message-----
From: Mark Leith [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Help needed
RTFM on auditing - this should provide all that you need. A good start would
be to read:
Oracle Concepts Guide - Chapter 28 - Auditing.
HTH
Mark
-----Original Message-----
Sent: Tuesday, August 07, 2001 09:00
To: Multiple recipients of list ORACLE-L
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>>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
