Home › Discussions › Questions & Answers › Controlling SQL Visibility in Concurrent Log Files

Controlling SQL Visibility in Concurrent Log Files

Avatar photoCustomer Questions & Answers 5 replies

To prevent unauthorized viewing of our report logic, we need to stop the SQL query from being printed in the concurrent request log file. Which profile option manages this?

5 replies

  • Support Enginatics

    You set the profile option ‘Blitz Report Include SQL in Log’. Setting it to ‘No’ ensures the report SQL is not included in the Blitz Report log file.

  • What is the default setting for this profile?

  • Support Enginatics

    The default setting is ‘Yes’ (meaning the SQL is included in the log).

  • If I disable logging the SQL, will debugging reports still be possible if they fail?

  • Support Enginatics

    Yes, the log file will still show the user entered parameter values and corresponding bind variables, which is crucial for debugging.

  • You must be logged in to reply to this post.