when procedure executed in SQLPLUS it generates audit in SYS.AUD$
when it executed from DBMS_JOB, no audit is generated any ideas?
tables are audited by access for insert and update
Do I have to enable sys auditing to get it to work?
Printable View
when procedure executed in SQLPLUS it generates audit in SYS.AUD$
when it executed from DBMS_JOB, no audit is generated any ideas?
tables are audited by access for insert and update
Do I have to enable sys auditing to get it to work?
Interesting as the behavior reprodcuces in 9i with an anonymous block
SQL> drop table t1
2 /
Table dropped.
SQL> create table t1 (c int)
2 /
Table created.
SQL> audit all on t1 by session
2 /
Audit succeeded.
SQL> insert into t1 values(1)
2 /
1 row created.
SQL> commit
2 /
Commit complete.
SQL> select userid,to_char(timestamp#,'hh24:mi:ss') audit_time from sys.aud$
2 /
USERID AUDIT_TIME
-------------------- ------------------------------
STMONTGO 21:17:16
SQL> begin
2 execute immediate ('insert into t1 values(2)');
3 end;
4 /
PL/SQL procedure successfully completed.
SQL> select userid,to_char(timestamp#,'hh24:mi:ss') audit_time from sys.aud$
2 /
USERID AUDIT_TIME
-------------------- ------------------------------
STMONTGO 21:17:16
SQL> select * from t1;
C
----------
1
2
Isn't it because auditing is for stadard SQL COMMANDS?
And packages/procedures that are derive from other source
like EXECUTE IMMEDIATE, IMMEDIATE here is an INTERNAL procedures that calls DBMS_SQL(native) commands prevent AUDITING from doing its task?
Just a wild idea. I would be very much glad if somebody can clear this thought ...:D :D
that could be, i could not find that documented though. that sucks though, you would think audit insert would audit insert when in reality some could easy cirumvent through an anonymous blockQuote:
Originally posted by reydp
Isn't it because auditing is for stadard SQL COMMANDS?
And packages/procedures that are derive from other source
like EXECUTE IMMEDIATE, IMMEDIATE here is an INTERNAL procedures that calls DBMS_SQL(native) commands prevent AUDITING from doing its task?
Just a wild idea. I would be very much glad if somebody can clear this thought ...:D :D
Why don't you raise a tar and post the results here, I'd be curious to see what theose redwood shores prima donna's have to sayQuote:
Originally posted by eugene
when procedure executed in SQLPLUS it generates audit in SYS.AUD$
when it executed from DBMS_JOB, no audit is generated any ideas?
tables are audited by access for insert and update
Do I have to enable sys auditing to get it to work?
my employer doesn't have support , so I can't log a tar..........
I couldn't find any docs related to this on metastink anyways......
guess I should abandon the 10g new cool feature and go to a regular trigger way of doing things..........
If this is the case, then oracle now can include this for there new patches or maintenance release. Or worse comes to worst have to wait for new version, maybe something like 11d(after 10g).:DQuote:
Originally posted by stmontgo
that could be, i could not find that documented though. that sucks though, you would think audit insert would audit insert when in reality some could easy cirumvent through an anonymous block