SAP-Forum.ORG
   

Go Back   SAP-Forum.ORG > SAP Forums > SAP BASIS

Similar Threads
Thread Thread Starter Forum Replies Last Post
SAP now supports Oracle 11g on Windows platform Portal SAP BASIS 2 07-08-2010 05:35 PM
Searching a Solution: Oracle Patch Error 10.2.0.4 SAPMM SAP BASIS 2 07-06-2010 05:51 PM
Oracle App Servers can't both be up at once Lala SAP BASIS 4 06-28-2010 12:22 AM
need urget: consultant sap, oracle, sql,.. compuaddy SAP Job Offered 0 07-27-2009 04:54 AM

Reply
 
Thread Tools Display Modes
  #1  
Old 07-08-2010, 06:17 PM
Lala Lala is offline
Senior Member
 
Join Date: May 2010
Location: Chicago
Posts: 379
Default Oracle auditing

Hello,

I am on Oracle 10.2.0.4 and have enabled Oracle auditing. When querying dba_audit_trail, I saw below output:

OS_USERNAME TERMINAL USERNAME TO_CHAR(TIMESTAMP,'DD-MON- OWNER OBJ_NAME
--------------------------------------------------------------------------------
--------------------
--------------------------------------------------------------------------------
--------------------------
--------------------------------------------------------------------------------
----------------------------------------
ACTION_NAME SES_ACTIONS
--------------------------------------------------------------------------------
-------------------

DOMAIN\SAPServicePRD B1AMSPRD SAPSR3 02-May-2010 12:58:16 SAPSR3 USR01
DELETE

How can I find out who ran the DELETE command on table USR01?

Thank you.

Just to add - Does the changing of <sid>adm password cause the system to issue a DELETE command on USR01 as this is the only activity that I can think of.
Reply With Quote
Sponsors
  #2  
Old 07-08-2010, 06:18 PM
Portal Portal is offline
Senior Member
 
Join Date: May 2010
Location: Miami
Posts: 752
Default Re: Oracle auditing

You will not be able to trace which SAP user deleted that record in that table using Oracle tools.
Reply With Quote
Entre a los Links relacionados
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 01:56 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Forum Design By inferno