Imperva Cyber Community

communities_1.jpg
 View Only
  • 1.  query raw limit

    Posted 03-04-2020 05:45
    Hi all,
    is there a limit in DAM to log a query?

    I saw the raw query data seems limited to 4K or 4000 chr.

    Can you please give me more references and tell me where I can modify that value?

    Thank you
    #DatabaseActivityMonitoring

    ------------------------------
    cm
    ------------------------------


  • 2.  RE: query raw limit

    Posted 03-04-2020 08:00
    Hello,

    Based on this link:  https://www.imperva.com/sign_in.asp?retURL=/articles/Reference/SQL-query-size-parsing-limit

    Question:
    =======
    There are two points regarding SQL query size.
    1.
    SecureSphere may not parse when the query is bigger 1 MB
    2. What is the Max query that SecureSphere will parse?

    Answer:
    ======
    1.
    Even when enabling "Enable support for queries or full-paths larger than 4k" at "Admin" > "System Definitions" > "Gateway Settings" > "Audit Settings".
    Parsing issue with SQL 2008 - SecureSphere may not parse when the query is bigger 1 MB.

    2.SecureSphere does parse and support Nested SQL, the limit is the limit of SQL query size parsing - which is 1MB

    Best,

    ------------------------------
    Sabajete Elezaj
    SNT Albania
    ------------------------------