Monitoring a user

[jh897]

I am trying to monitor a user who seems to be submitting "questionable" SQL. Is there a way to actually log the statements that he is submitting? I have read through the Begin/End Logging section of the Security Administration guide, but I still am not seeing it. Thanks in advance for any help.

 

[tdgulbra]

Try the following syntax:

Begin logging on each select on user username;

The results should be stored in dbc.accesslog

Is there something I am missing about your request?

Tony

 

[tdatgod]

if you have Teradata Manger 5.0 and v2r4.1.x you can actually see the Executing SQL of the questionable session while it is running.

----

 

[jh897]

The show SQL feature of Teradata Manager is helpful. I was wanting to keep some short-term history on this user by logging his SQL activity. I succeeded in enabling the logging using the Begin Logging statement. It is straightfoward, but for some reason I was struggling with the syntax/options. Thanks again for your help.

 

[RogerCruse]

We've setup LOGGING on all user activity and keep this data for five weeks.

I'm assuming you've setup your user access via VIEWS that are different from the VIEWS that are used by your ETL process? Because LOGGING will impact the performance of the ETL process if you don't.

You can then create a simple report (we use Business Objects) to provide an analysis of active users / tables / busy times / etc.

If you want to keep more than 5 weeks, then copy this data into a dedicated table as this will be faster, won't impact your logging and you can extend the data if you want to.

Roger...