Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Identify Table READERS without Audit in Sybase

28 views
Skip to first unread message

rkbalan

unread,
Mar 30, 2012, 1:19:11 AM3/30/12
to
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 (we believe we have all the writers captured). 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.

rkbalan

unread,
Mar 30, 2012, 1:21:38 AM3/30/12
to

ziona...@gmail.com

unread,
Apr 16, 2012, 4:12:13 AM4/16/12
to
If you could move to at least Sybase 12.5.3, then you could use the virtual tables feature, but it the version you currently use i dont see any clue for your constraint.
0 new messages