DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: AUDITING??

  1. #1
    Join Date
    Jul 2000
    Location
    india
    Posts
    213

    Thumbs up

    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

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  3. #3
    Join Date
    Jul 2000
    Location
    india
    Posts
    213
    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

  4. #4
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  5. #5
    Join Date
    Jul 2000
    Location
    india
    Posts
    213

    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

  6. #6
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    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

  7. #7
    Join Date
    Sep 2000
    Posts
    384
    for a easy trouble free approach use triggers .You have full control over it.
    Radhakrishnan.M

  8. #8
    Join Date
    Jul 2000
    Posts
    296
    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.


  9. #9
    Join Date
    Jul 2000
    Posts
    296
    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;

  10. #10
    Join Date
    Jul 2000
    Location
    india
    Posts
    213

    Thumbs up

    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
  •  


Click Here to Expand Forum to Full Width