Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.sybase > #608

Re: Identify Table Users without Audit in Sybase

Show all headers | View raw

>
>The DBA tells me that audits can be enabled only on the entire database and is out of the question. 
> 

You can selectively audit an object:

sp_audit 'select','all','your_table_name','on'

Above command will audit all select access to the specified table. Do the same for as many tables as you need to know about. If the auditing burden is considered too high, you can audit a few at a time.

Likewise, you can audit any stored procs that read from the table to see who is calling them. Auditing is your friend - use it :)

Back to comp.databases.sybase | Previous | Next — Previous 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