Spread the word.

Share the link on social media.

Share
  • Facebook
Have an account? Sign In Now

Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have permission to ask a question, You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

SIKSHAPATH

SIKSHAPATH Navigation

  • Home
  • Questions
  • Blog
    • Computer Science(CSE)
    • NPTEL
    • Startup
  • Shop
    • Internshala Answers
Search
Ask A Question

Mobile menu

Close
Ask A Question
  • Home
  • Questions
  • Blog
    • Computer Science(CSE)
    • NPTEL
    • Startup
  • Shop
    • Internshala Answers
Home/ Questions/Q 7106
Next
In Process

SIKSHAPATH Latest Questions

SUMIT
  • 1
  • 1
SUMIT
Asked: November 19, 20212021-11-19T19:57:12+05:30 2021-11-19T19:57:12+05:30In: DBMS

List triggers that can be used for table auditing?

  • 1
  • 1

List triggers that can be used for table auditing?

list triggers that can be used for table auditing
  • 1 1 Answer
  • 2k Views
  • 0 Followers
  • 0
Answer
Share
  • Facebook

    1 Answer

    • Voted
    • Oldest
    • Recent
    1. I'M ADMIN
      I'M ADMIN
      2021-11-19T20:37:24+05:30Added an answer on November 19, 2021 at 8:37 pm
      Triggers are commonly used to supplement the built-in auditing features of Oracle. 
      Although triggers can be written to record information similar to that recorded by the AUDIT command, 
      triggers should be used only when more detailed audit information is required. For example, use triggers
      to provide value-based auditing on a per-row basis for tables.
      
       Currently, four types of triggers exist in SQL Server, and the first two are the most commonly used:
      • DDL triggers (auditing CREATE, ALTER, DROP and several system-defined stored procedures which perform DDL operations) are often used for administrative tasks like regulating and auditing database operations
      • DML triggers – our focus will be on this type of trigger as they provide auditing of data changes. This type of audit triggers fires upon DML statements (like INSERT, UPDATE, and DELETE) as well on stored procedures that execute DML-like operations
      • CLR triggers are a special type of auditing triggers that enables trigger techniques to be used directly within .NET languages, and they support SQL Server 2008 and above
      • Logon triggers fire when a SQL Server LOGON event occurs. It can be used to track successful authentication and control and audit server sessions
        • 2
      • Reply
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn

    Leave an answer
    Cancel reply

    You must login to add an answer.

    Forgot Password?

    Need An Account, Sign Up Here

    Sidebar

    store ads

    Stats

    • Questions 1k
    • Answers 1k
    • Posts 149
    • Best Answers 89
    • This Free AI Tool Translates Entire Books in Minute !
    • AI News: 🎬 Hollywood’s AI Studios, 🎓 OpenAI’s Latest Gift to Educators, 🚚 Class8 Bags $22M, 🧠 Google Gemini’s Memory Upgrade
    • AI NEWS: Legal Action Against OpenAI, $16M Paid, & Elon Musk’s Praise from Investor 🤖💰📑 | AI Boosts Cloud Seeding for Water Security 🌱💧
    • AI News: 🎬AI Video Tool Scam Exposed🤯, 🛰️ AI-Powered Drones to Ukraine 😱, Google’s $20M AI Push, Sam Altman Joins SF’s Leadership Team
    • AI News: 🤝 Biden Meets Xi on AI Talks, 💡 Xavier Niel’s Advice for Europe, ♻️ Hong Kong’s Smart Bin Revolution, 🚀 AI x Huawei

    Explore

    • Recent Questions
    • Questions For You
    • Answers With Time
    • Most Visited
    • New Questions
    • Recent Questions With Time

    Footer

    SIKSHAPATH

    Helpful Links

    • Contact
    • Disclaimer
    • Privacy Policy Notice
    • TERMS OF USE
    • FAQs
    • Refund/Cancellation Policy
    • Delivery Policy for Sikshapath

    Follow Us

    © 2021-24 Sikshapath. All Rights Reserved

    Insert/edit link

    Enter the destination URL

    Or link to existing content

      No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.