At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
COURSE of the MONTH
11 days, 22 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.
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 the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
This article will show how Aten was able to supply easy management and control for Artear's video walls and wide range display configurations of their newsroom.
- Networking Hardware-Other
- MultiMedia Applications
- Switches / Hubs
- Displays / Monitors
- ATEN Technology
- Hardware, Network Architecture, *Kernel-based Virtual Machine (KVM)
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month11 days, 22 hours left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.