|
Home > Archive > SQL Anywhere database > May 2005 > How to monitor user activitiy?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to monitor user activitiy?
|
|
| Jack Ling 2005-05-23, 3:23 am |
| Hi,
We have a system using Sybase Anywhere 6. But I'm not
familiar w/ Sybase.
My question: is there a way to show when did a user (a
database user e.g. dba) perform actions (like insert, edit,
delete, update on tables) on a database? and how to get this
info?
best regards,
Jack Ling
fly2moon2@yahoo.com
| |
| Glenn Paulley 2005-05-23, 9:23 am |
| Jack Ling wrote in news:4291591f.51f2.1681692777@sybase.com:
> Hi,
>
>
> We have a system using Sybase Anywhere 6. But I'm not
> familiar w/ Sybase.
>
> My question: is there a way to show when did a user (a
> database user e.g. dba) perform actions (like insert, edit,
> delete, update on tables) on a database? and how to get this
> info?
>
> best regards,
> Jack Ling
> fly2moon2@yahoo.com
>
SQL Anywhere has an "auditing" capability that can do this. It was first
introduced in the 6.0.02 release, and has been steadily broadened and
improved in subsequent releases. Look in the help under "auditing
option".
--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
|
|
|
|
|