SAP Knowledge Base Article - Public

3769284 - SELECT * query fails with permission error

Symptom

SELECT * query fails with permission error when trying to access tables.

Environment

SAP CPQ

Reproducing the Issue

  1. Open Quote
  2. Open script workbench 
  3. a = SqlHelper.GetList("""
    SELECT *
    FROM users
    """)

Cause

The SELECT permission was denied on the column tables.

Resolution

  • This action is no longer available due to a security update. Access to tables containing sensitive data is now restricted
  • Queries against non-sensitive data such as products and attributes remain supported.

Keywords

Select, script workbench, quote, error, tables, CPQ , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , How To

Product

SAP CPQ all versions