sybase sp_audit

experts,

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?

thanks in advance,
telliot79Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
BenSladeConnect With a Mentor Commented:
"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?
0
 
BenSladeCommented:
Try the Sybase product manual page at:

sybase.com > Support > Product Documenttion > Product Category > Database Management > Adaptive Server Enterprise > Adaptive Server Enterprise 15.0 - English > Adaptive Server Enterprise 15.0 (expand table of contents entry) >  System Administration Guide: Volume 1 (expand table of contents entry) > Auditing (expand table of contents entry) > Setting global auditing options (expand table of contents entry) > Auditing options: types and requirements

at the web address:

infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.sag1/html/sag1/sag1859.htm
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.