Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Nov 23rd, 2017, 6:59am
News: If you would like to register contact the forum admin
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle Security
   Oracle Auditing
(Moderator: Pete Finnigan)
   Auditing while audit trail = NONE
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Auditing while audit trail = NONE  (Read 3264 times)
thoholm
PeteFinnigan.com Newbie
*



New at Oracle

   
View Profile |

Gender: male
Posts: 2
Auditing while audit trail = NONE
« on: Jul 1st, 2008, 12:45pm »
Quote | Modify

Hi,
 
I have a question. Is it possible to audit while audit trail = NONE?
I've heard that it should be possible to enable audit with SQL commands. Is this correct?
 
Thanks
IP Logged
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Auditing while audit trail = NONE
« Reply #1 on: Jul 12th, 2008, 7:50pm »
Quote | Modify

I think you probably mean Fine Grained Audit that allows audit of SQL statements amongst other things. Also you can use triggers, system triggers, redo logs, commercial products such as Sentrigo Hedgehog....
 
Have a look at Fine Grained Audit
 
cheers
 
Pete
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
thoholm
PeteFinnigan.com Newbie
*



New at Oracle

   
View Profile |

Gender: male
Posts: 2
Re: Auditing while audit trail = NONE
« Reply #2 on: Jul 14th, 2008, 7:29am »
Quote | Modify

Hi Pete
 
I spend a few hours reading about auditing and I came to the same conclusion.
My problem is that it is not possible to view the audit parameter if it has been set with a SQL statement.
 
Cheers
 
Thomas
IP Logged
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Auditing while audit trail = NONE
« Reply #3 on: Jul 14th, 2008, 3:32pm »
Quote | Modify

Hi Thomas,
 
Thanks for your reply. Now I have re-read your question and this answer I am not now convinced I answered your question.
 
Are you:
 
1) suggesting its possible to turn on audit (i.e. set audit_trail) without setting it in the spfile/init.ora file?
 
2) or are you confusing the setting of audit with the parameter that turns it on. i.e. if i want to audit session I issue, "AUDIT SESSION" but it doesnt work until audit is turned on in the init/spfile.
 
3) I would guess that these audit (in 2 above) can be set via SQL easily by updating the dictionary.
 
please clarify what you mean.
 
cheers
 
Pete
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
thoholm
PeteFinnigan.com Newbie
*





   
View Profile |

Gender: male
Posts: 2
Re: Auditing while audit trail = NONE
« Reply #4 on: Mar 10th, 2009, 8:26am »
Quote | Modify

Hi Pete,
 
Sorry, I actually forgot I posted an issue here.
 
The issue was that I was wondering if it was possible to turn on auditing without changing the parameter i.e. using a SQL statement (and thereby changing the setting in the ini.ora file).
 
Cheers
 
Thomas
IP Logged
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Auditing while audit trail = NONE
« Reply #5 on: Mar 10th, 2009, 2:53pm »
Quote | Modify

Hi Thomas,
 
Thanks for your post. No you must enable the audit_trail parameter either in the init.ora or spfile.ora depending on what you are running.  
 
cheers
 
Pete
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board