?
Solved

Sybase Auditing in Version 11.0.2

Posted on 2004-10-14
2
Medium Priority
?
350 Views
Last Modified: 2012-06-27

Hi ,

I have A sybase database version11.0.2, I dont have the sybsecurity database installed.
What are the other ways of auditing the sybase database.

thanks
Vin
0
Comment
Question by:vijadon
[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 Comments
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 750 total points
ID: 12313478
Depends on what you're wanting to do.

For very simple stuff, i.e. logging inserts/updates/deletes, you could have a trigger that also writes to some custom audit table. You'd have to write this per table you wanted to audit, and it wouldn't allow you to (for example) audit selects.

There are some not-really-documented trace flags that could give the Sybase errorlog more verbose error reporting, or log all login requests, etc. I'm not sure whether those existed at the 11.0.2 level.

For any "real" auditing solution, you need the standard Sybase auditing capabilities. There should be a script to install this in the "scripts" subdirectory.

The other main approach is to code this in your client application, but that means anyone directly connecting to the database will bypass the application auditing.
0
 
LVL 24

Expert Comment

by:Joe Woodhouse
ID: 12417499
Thank you, and good luck!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

This is a fine trick which I've found useful many times, when you just don't want to accidentally run a batch script or the commands needs administrator rights.
The top devops trends for 2017 are focused on improved deployment frequency, decreased lead time for change and decreased MTTR.
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, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

765 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