Solved

sybase sp_audit

Posted on 2012-04-13
4
1,214 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

CTAs encourage people to do something specific to show interest in your company, product or service. Keep reading to learn why CTAs should always be thought of as extremely important, albeit small, sections of websites.
A big percent of today’s marketing activity is performed through the online environment. The marketing strategies that have existed a decade ago no longer relate to what’s happening today. We’re currently facing a revolutionary era, called the digit…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Suggested Courses

738 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