If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

SQL + userid

Started by tommeyers, 07 Feb 2020 02:58:10 PM

Previous topic - Next topic

tommeyers

Is there a way to log SQL with userid. Is that available through Audit. I ultimately will use this to report on what data columns a user reported on looking for insider mining of our data.

dougp

User names are logged in the Audit database.  You may need to enable Native Query logging.  Even if you do, you won't see the query for reports that fail.  It's logged after successful completion.  (Same with parameters.)

Andrei I