All Forums Database
Greyghost 51 posts Joined 07/09
25 Jan 2011
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

dnoeth 4628 posts Joined 11/04
25 Jan 2011

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

Dieter

You must sign in to leave a comment.