I'm researching auditing of my sybase ASE server and am trying to find documentation that will explain the difference between the 'all' and 'cmdtext' setting for the option parameter of the sp_audit procedure.
sybase online isn't exactly clear. if i want to audit everything a certain user does, which one of these settings should i use? or both?
"all" (for the 1st param=the type of auditing), audits all actions (eg. create/drop/grant, etc), but doesn't audit the actual SQL text of a command for a user.
cmdtext just logs the SQL text and none of the other actions.
0
telliot79Author Commented:
increasing points to gain interest??
0
telliot79Author Commented:
thanks for the answer. is there any documentation on this online that you can point me towards?
cmdtext just logs the SQL text and none of the other actions.