Solved

Sybase Auditing in Version 11.0.2

Posted on 2004-10-14
2
348 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 250 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 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