Database Access Logging/Reporting

Database
Teradata Employee

Database Access Logging/Reporting

Hi All,

Is there a way to track users who access a particular database in the data warehouse? Would this be done thru the DBQL? Are there any "standard" sql reports that exist for this kind of reporting? This is needed for security reporting requirments.

Thanks!

Paul
1 REPLY
N/A

Re: Database Access Logging/Reporting

Hi Paul,
what you need is the Access Log but not DBQL, e,g:

BEGIN LOGGING WITH TEXT ON FIRST AND LAST ALL ON DATABASE dbname;

Check the Security Administration manual for details,
Chapter 10: Monitoring Database Access

Dieter