Identify Table Users without Audit in Sybase

From	rkbalan <rajkbalan@gmail.com>
Newsgroups	comp.databases.sybase
Subject	Identify Table Users without Audit in Sybase
Date	2012-03-29 03:53 -0700
Organization	http://groups.google.com
Message-ID	<24339140.2200.1333018435484.JavaMail.geo-discussion-forums@vbtv42> (permalink)

Show all headers | View raw

Hi,

We are in the process of moving an application (and its tables) out of a 11.9.2 Sybase database and found that there could be several unknown readers of data from those tables. The tables here are a subset (approx 35 tables) of the entire database (approx 800 tables).

The technical & hardware constraints do not allow us to turn on Audits. The DBA tells me that audits can be enabled only on the entire database and is out of the question. 

Is there any option/method that would allow us to identify the readers of the tables. If there are other forums that this question could be posted on please let me know. Thanks,

- rkb.

Back to comp.databases.sybase | Previous | Next — Next in thread | Find similar

Thread

Identify Table Users without Audit in Sybase rkbalan <rajkbalan@gmail.com> - 2012-03-29 03:53 -0700
  Re: Identify Table Users without Audit in Sybase bret_halford@msn.com - 2012-03-29 09:43 -0700
  Re: Identify Table Users without Audit in Sybase Antony <albion26.eve@gmail.com> - 2012-04-03 22:04 -0700

csiph-web