[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now



Posted on 2012-09-20
Medium Priority
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

Joe Woodhouse earned 2000 total points
ID: 38423757
table_access audits select, delete, update and insert commands on a table.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

834 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