Sybase-sp_audit

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
motioneyeAsked:
Who is Participating?
 
Joe WoodhousePrincipal ConsultantCommented:
table_access audits select, delete, update and insert commands on a table.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.