DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Security

  1. #1
    Join Date
    Aug 2001
    Posts
    134

    Thumbs down

    On one database with same password users perform DML commands from different terminals, how i can detect who perform update or delete and that entries are save in a table with terminal name and user ?
    Thanx

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Trigger on the table and select from v$session.machine or osuser.

    I suppose you could use the auditing features to do this too.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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