Transaction Log for One SQL User

[former_SQLA_member1695081]

Hello,

I need to find all of the statements and changes one particular user has executed in SQL Anywhere. I opened up Sybase Central. I went to tools --> SQLAnywhere 16 --> Translate Log File.

I went through the wizard and selected all of the parameters. It asked me to select a specific user, and I tried typing in that person's username and ID. Neither of them worked.

How can I get the log info that I'm looking for?

[VolkerBarth]

According to the DBTRAN utility, the according - u option requires a "userid", which means the username itself. I'd suggest to try that utility.