Ansicht
Dokumentation

ABENSQL_INJ_OS_QUERY_SCRTY - SQL INJ OS QUERY SCRTY

SQL Injections Using Object Services

Filter conditions are passed to a query as character strings in the query service in the Object Services. If a filter condition like this (or part of it) originates outside the program, the same risk of an SQL injection is incurred as when a dynamic WHERE condition is manipulated in . To prevent SQL injections of this nature, either parameters from a parameter list or must be used or parts escaped using the class CL_ABAP_DYN_PRG.

Example

The executable example DEMO_QUERY_SERVICE is secure, since the interactive input is passed to the query using parameter bindings. If the source code after the statement TRY is replaced as follows, however, SQL injections are possible:

TRY.
    query_manager = cl_os_system=>get_query_manager( ).
    query = query_manager->create_query(
              i_filter  = `AIRPFROM = '` &&  airpfrom  &&
                           `' AND AIRPTO = '` && airpto  && `'` ).
    connections =
      agent->if_os_ca_persistency~get_persistent_by_query(
               i_query = query ).
    ...

If airpfrom and airpto contain the values "FRA' OR AIRPFROM <> '" and "SIN' OR AIRPTO <> '", for example, all existing data is read. If no parameter bindings are used, therefore, airpfrom and airpto must be escaped.

   query = query_manager->create_query(
      i_filter  = `AIRPFROM = ` &&
                  cl_abap_dyn_prg=>quote( airpfrom ) &&
                  `  AND AIRPTO = ` &&
                  cl_abap_dyn_prg=>quote( airpto ) ).