<div>
<div class="content wysiwyg-content">
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 &nbsp;provide auditing for &nbsp;delete and update or drop statement ? or it just access to the table something like &quot;select&quot;?<br />
<br />
2&gt; 1&gt; sp_displayaudit<br />
2&gt;<br />
No sprocs/triggers currently have auditing enabled.<br />
No databases currently have default sproc/trigger auditing enabled.<br />
No objects currently have auditing enabled.<br />
No databases currently have default table/view auditing enabled.<br />
&nbsp;Login Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Audit Option &nbsp; Value<br />
&nbsp;--------------------------<wbr />----- -------------- -----<br />
&nbsp;samkry &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table_access &nbsp; on<br />
&nbsp;kzal &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table_access &nbsp; on<br />
&nbsp;SA2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;table_access &nbsp; on<br />
&nbsp;ShellUser &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;table_access &nbsp; on<br />
&nbsp;sa &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; table_access &nbsp; on
</div>
</div>


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
2>
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

Sybase-sp_audit

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.