Posted on 2012-09-20
Last Modified: 2012-09-25
I'm trying to figure out what we audit in our sybase db, what been audited now is tables_access option is set to ON. So my questions is will this option  provide auditing for  delete and update or drop statement ? or it just access to the table something like "select"?

2> 1> sp_displayaudit
No sprocs/triggers currently have auditing enabled.
No databases currently have default sproc/trigger auditing enabled.
No objects currently have auditing enabled.
No databases currently have default table/view auditing enabled.
 Login Name                      Audit Option   Value
 ------------------------------- -------------- -----
 samkry                         table_access   on
 kzal                           table_access   on
 SA2                                 table_access   on
 ShellUser                      table_access   on
 sa                             table_access   on
Question by:motioneye
    1 Comment
    LVL 24

    Accepted Solution

    table_access audits select, delete, update and insert commands on a table.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Join & Write a Comment

    Suggested Solutions

    Synchronize a new Active Directory domain with an existing Office 365 tenant
    Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now