-
Hi everybody,
if on sql> i give the follo command
AUDIT INSERT,UPDATE ON SCHEMA.TABLE_NAME
WHENEVER SUCCESSFULL;
It gives me
Audit succeeded
Then i inserted a row in the table table_name.
after this i gave the
SELECT OBJ_NAME,ACTION_NAME FROM DBA_AUDIT_OBJECT where
OBJ_NAME='TABLE_NAME';
Which gives me the output as
OBJ_NAME ACTION_NAME
-------------------- -----------------------
TABLE_NAME SESSION REC
MY question is why it does not show me INSERT in place of SESSION REC
and what does SESSION REC mean...
I also queried the view AUDIT_ACTIONS
SQL> select * from audit_actions;
ACTION NAME
--------- ---------------------------
0 UNKNOWN
1 CREATE TABLE
2 INSERT
Here the INSERT action is there then why it is not giving me the INSERT in the previous query.....
Hope u all will understand what my prob is.
Pls help if anybody knows the explanation.
thanks in advance
pras
-
Try this way
Hi, 12th May 2001 21:24 hrs *******
http://www.oradoc.com/ora816/server....6961/ch217.htm
Try this way out.
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
Hi Padmam,
thanks for ur help,but still i am unable to understand what ur trying to tell...i queried the view ALL_DEF_AUDIT_OPTS and got the follo info
SQL> select * from all_def_audit_opts;
ALT AUD COM DEL GRA IND INS LOC REN SEL UPD REF EXE
--- --- --- --- --- --- --- --- --- --- --- --- ---
-/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/- -/-
-/- : no default auditing
S/- : auditing whenevere successful
that means all my columns set to no default auditing when i created the objects, can u pls tell what should i have to do to set it to the S/- (auditing whenevere successful) or -/S (auditing whenever not successful )..
pls help...and thanks once again...
pras
-
On investigation
Hi, 15th May 2001 18:11 hrs *******
I am on the process to find a solution for your problem.
Please mean while follow up on this 2 link even though it may be little use for your needs.
http://oradb1.jinr.ru/oracle/srvr/se...h21.htm#object auditing
http://otn.oracle.com/support/s_repo...ent/428695.htm
I will get back to you after more investigation.
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
waiting for reply
Hi Padmam
Thank you very much for showing keen interest on this thread..i am eagerly waiting for ur reply.
In the mean time i am also searching the solution.
Thanks and regards
pras
-
Re: Follow Up
Dear Pras, 18th May 2001 18:21 hrs chennai
I am really sorry for the delay .I feel we could now interact on day to day basis to sort this problem out.
1)I was first unable to locate your problem in the forum.Since the search option is not woking.I was searching from 1..7 pages one by one.
2)i already worked on you r problem over few hours on test environment.
I have few clarifications from you i will back to you tommorow to sort the whole issue.Hope sat you can spend more time on the same.
Cheers
Padmam
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
for a easy trouble free approach use triggers .You have full control over it.
Radhakrishnan.M
-
Triggers are not trouble free and not always easy. With triggers you cannot audit SELECT statements, and AUDIT works independent from COMMIT or ROLLBACK. Auditing is easier to enable and disable.
The link http://oradb1.jinr.ru/oracle/srvr/se...h21.htm#object auditing
Padman provided explains what is going on.
You can audit by session or by access. By session, one record per session is inserted in the audit trail. By acces for every access is a record inserted in th eaudit trail. By session is the default.
SESSION REC means entry is a session record, in column SES_ACTIONS you can find actions: a varchar2, for every position an action:
-: not
s: succesful
f: failure
b: both
in order (for Oracle 7): alter, audit, comment, delete, execute, grant, index, insert, lock, rename, select, update.
----------S- means object is only selected in this session.
---F---S--SS means delete from object failed, insert, select and update succeeded.
-
If you want to audit by access:
AUDIT update ON scott.emp BY ACCESS;
If you want only successful entries:
AUDIT insert ON scott.dept BY ACCESS WHENEVER SUCCESSFUL;
or only not succesful:
AUDIT update ON scott.emp BY SESSION WHENEVER NOT SUCCESSFUL;
-
Hi,
Akkerend and Padmam,
Thanks a lot to both of you...U really made my day..
Now i am very much clear on this issue and the diff btw
BY SESSION and BY ACCESS..
Thanks again..
pras
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|