ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Course Of The Month
1 day, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
sybase sp_audit
Posted on 2012-04-13
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,
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,
[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
"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.
cmdtext just logs the SQL text and none of the other actions.
Active today
thanks for the answer. is there any documentation on this online that you can point me towards?
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
A couple of months ago we ran into an issue that necessitated re-creating our Edge Subscriptions. However, when we attempted to execute the command: New-EdgeSubscription -filename C:\NewEdgeSub_01.xml we received an error indicating that the LDAP se…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar.
Int…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Course of the Month1 day, 23 hours left to enroll
717 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.