Home » RDBMS Server » Security » To know the user delete the table ?
To know the user delete the table ? [message #238689] Sat, 19 May 2007 01:36 Go to next message
namcit
Messages: 2
Registered: May 2007
Junior Member

Dear advisor !

I use Database Oracle 9i. Please tell me how to know the user the delete the table.

The time ? The computername ? The tool ? .etc

Thank for all consider
Re: To know the user delete the table ? [message #238692 is a reply to message #238689] Sat, 19 May 2007 02:11 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

You should enable AUDITDING for trace any activity on your database.

http://download-uk.oracle.com/docs/cd/B14117_01/server.101/b10743/security.htm


Regards
Taj

[Updated on: Sat, 19 May 2007 02:12]

Report message to a moderator

Re: To know the user delete the table ? [message #238723 is a reply to message #238689] Sat, 19 May 2007 13:28 Go to previous messageGo to next message
saisingaram
Messages: 1
Registered: May 2007
Location: englAna
Junior Member
hi all

can any bodu suggest me how is this sap fico.? is it woth while to learn?
Re: To know the user delete the table ? [message #238728 is a reply to message #238723] Sat, 19 May 2007 14:03 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
TRUN THE AUIDTING ON BY PARAMETER
AUDIT_TRAIL=TRUE

AND THEN

AUDIT DROP ANY TABLE BY (ACCESS OR USERNAME)

IF U WANT TO KNOW WHO DELETE THE ROWS FROM TABLE FOR THAT YOU MUST USE DBMS_FGA PACKAGE
TAKE A LOOK OVER HERE

https://www.psoug.org/reference/dbms_fga.html

Re: To know the user delete the table ? [message #238732 is a reply to message #238728] Sat, 19 May 2007 14:15 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
KEEP OFF YOUR FINGER FROM CAPS LOCK key.

Regards
Michel
Re: To know the user delete the table ? [message #238733 is a reply to message #238732] Sat, 19 May 2007 14:16 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
CAPSLOCK??
HEHEH
okay
Re: To know the user delete the table ? [message #238744 is a reply to message #238689] Sat, 19 May 2007 15:09 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>IF U WANT TO KNOW WHO DELETE THE ROWS FROM TABLE
Alternatively one could use LOGMINER for all of the above.
Previous Topic: for creating table in new user
Next Topic: Restricting users
Goto Forum:
  


Current Time: Fri Mar 29 10:12:19 CDT 2024