SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Oracle auditing based on application

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Oracle auditing based on application
Author Message
Nalini



Joined: 19 Jul 2006
Posts: 2

Post Oracle auditing based on application Reply with quote

Hello all,

Has anyone had the need to audit Oracle SQL based on the application? For example, I need to audit statements that were issued from SQL*Plus, and not from other tools - like Oracle Apps. Does this product do that?

Thank you

Nalini

Wed Jul 19, 2006 12:10 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Oracle auditing based on application Reply with quote

You can audit data changes by application and filter out all changes made from SQL*Plus using inclusive filter type or if you use an exclusive filter you can audit changes made from any application but the Oracle Apps.

For user activity auditing (SELECTs, EXECUTEs, UPDATEs, CREATEs, etc...) there is no application name filter support for Oracle at this time. However if your Oracle Apps are run mostly on the server you can filter out anything that comes from all other places and/or users and this way find all backdoor access.

: Hello all,

: Has anyone had the need to audit Oracle SQL based on the application? For
: example, I need to audit statements that were issued from SQL*Plus, and
: not from other tools - like Oracle Apps. Does this product do that?

: Thank you

: Nalini

Wed Jul 19, 2006 12:48 pm View user's profile Send private message
Nalini



Joined: 19 Jul 2006
Posts: 2

Post Re: Oracle auditing based on application Reply with quote

Hello, thank you for your prompt response. I need to be able to audit updates as well. Could you point me to documentation that tells me exactly what can be audited and how, using your product?

Is there a way we can get a demo of the product?

Nalini

: You can audit data changes by application and filter out all changes made
: from SQL*Plus using inclusive filter type or if you use an exclusive
: filter you can audit changes made from any application but the Oracle
: Apps.

: For user activity auditing (SELECTs, EXECUTEs, UPDATEs, CREATEs, etc...)
: there is no application name filter support for Oracle at this time.
: However if your Oracle Apps are run mostly on the server you can filter
: out anything that comes from all other places and/or users and this way
: find all backdoor access.

Mon Jul 24, 2006 3:53 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Oracle auditing based on application Reply with quote

If you need to know only which table(s) got updated, when, by whom, and how (SQL command), read CHAPTER 3, for a config screen example, see page 34.
If you need to know what exactly got changed including before update and after update values, read CHAPTER 4, for a config screen example, see page 82

: Hello, thank you for your prompt response. I need to be able to audit updates
: as well. Could you point me to documentation that tells me exactly what
: can be audited and how, using your product?

: Is there a way we can get a demo of the product?

: Nalini

Wed Jul 26, 2006 9:19 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.