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

Controlling SQL Visibility in Concurrent Log Files

Avatar photoCustomer April 9, 2023 at 7:03 am

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?

Viewing 4 reply threads
  • Author
    Replies
    • Support April 10, 2023 at 11:57 am  

      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.

    • Avatar photoCustomer April 11, 2023 at 4:24 pm  

      What is the default setting for this profile?

    • Support April 13, 2023 at 8:55 am  

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

    • Avatar photoCustomer April 15, 2023 at 6:10 am  

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

    • Support April 15, 2023 at 9:17 pm  

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

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: