Solved

sybase sp_audit

Posted on 2012-04-13
4
1,169 Views
Last Modified: 2012-04-16
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,
0
Comment
Question by:telliot79
  • 2
  • 2
4 Comments
 

Author Comment

by:telliot79
ID: 37844721
increasing points to gain interest??
0
 
LVL 1

Accepted Solution

by:
BenSlade earned 250 total points
ID: 37844954
"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
 

Author Closing Comment

by:telliot79
ID: 37844971
thanks for the answer. is there any documentation on this online that you can point me towards?
0
 
LVL 1

Expert Comment

by:BenSlade
ID: 37851464
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

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

With the rapid rise in mobile usage, mobile devices are here to stay and have become an integral part of doing business. Here are 9 great apps for your BYOD environment.
A simple overview of the possibilities of using technology for project management.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

864 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now