Home » SQL & PL/SQL » SQL & PL/SQL » unable to audit
unable to audit [message #241560] Wed, 30 May 2007 01:00 Go to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
i am trying to audit, finding out which procedures are
called when i do things in my application

according to the docs, the process is

1)initSID.ora parameter: audit_trail

audit_trail='OS'

i have 10g server, i dont find this file in my system

2) audit INSERT TABLE, EXECUTE PROCEDURE BY user1, user2

i am able to connect to sys, and execute the above command
but nothing is happening



Re: unable to audit [message #241564 is a reply to message #241560] Wed, 30 May 2007 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NEVER EVER use SYS but for maintenance purpose (startup, shutdown, recover...)
Use another user.

Moreover you say you audit user1 and user2 not SYS.
In addition, SYS is audited in another way using "audit_sys_operations" parameter.

Regards
Michel
Re: unable to audit [message #241568 is a reply to message #241560] Wed, 30 May 2007 01:12 Go to previous messageGo to next message
soujanya_srk
Messages: 111
Registered: November 2006
Location: HYDERABAD
Senior Member
i want to audit user1 and user2, meaning whenever
from my application i make changes, i want to know what
procs are called in these 2 schemas
Re: unable to audit [message #241571 is a reply to message #241564] Wed, 30 May 2007 01:20 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Wed, 30 May 2007 08:05
NEVER EVER use SYS but for maintenance purpose (startup, shutdown, recover...)
Use another user.


In my opinion, enabling audit could be one of SYS' tasks, as you might want to enable auditing on 'power-users' (i.e. other dba-users) as well
Re: unable to audit [message #241575 is a reply to message #241571] Wed, 30 May 2007 01:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Audit is a task of a security dba but not SYS.
SYS is for maintenance.
Try to open a SR and say I did that with SYS, either Oracle support asks you to reproduce with another user or they close the SR.

When you use SYS you don't use the same code as with another user.

Regards
Michel
Re: unable to audit [message #241622 is a reply to message #241575] Wed, 30 May 2007 03:46 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
I know and I agree in normal, day to day business.
It's just that enabling auditing _could_ be an exception in my view...
Previous Topic: Can put nls format into procedure......
Next Topic: Date conversion function
Goto Forum:
  


Current Time: Fri Dec 09 00:04:57 CST 2016

Total time taken to generate the page: 0.18762 seconds