[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Sybase Auditing in Version 11.0.2

Posted on 2004-10-14
2
Medium Priority
?
351 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
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…

650 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