case insensitive search for ANALYTIC_PRIVILEGES.USER_NAME

29 Views

select "COLUMN_OBJECT", "CATALOG_NAME", "CUBE_NAME", "DESCRIPTION", "VIEW_TYPE" FROM "_SYS_BI"."BIMC_CUBES" BIMC_CUBES INNER JOIN "SYS"."ACCESSIBLE_VIEWS" ANALYTIC_PRIVILEGES ON (BIMC_CUBES."CATALOG_NAME" || '/' || BIMC_CUBES."CUBE_NAME" = ANALYTIC_PRIVILEGES."VIEW_NAME") LEFT OUTER JOIN "SYS"."VIEWS" VIEWS_INFO ON (ANALYTIC_PRIVILEGES."VIEW_NAME" = VIEWS_INFO."VIEW_NAME") WHERE upper(ANALYTIC_PRIVILEGES.USER_NAME) = upper('system') AND ANALYTIC_PRIVILEGES.SCHEMA_NAME = '_SYS_BIC' ORDER BY "CATALOG_NAME" ASC, "CUBE_NAME" ASC

I am trying to run the above query in hana system and it fails with following error:

Could not execute 'select "COLUMN_OBJECT", "CATALOG_NAME", "CUBE_NAME", "DESCRIPTION", "VIEW_TYPE" FROM ...' in 247 ms 718 µs .

SAP DBTech JDBC: [8]: invalid argument: SELECT without WHERE clause USER_NAME = ... not supported

I want to perform a case insensitive search on ANALYTIC_PRIVILEGES.USER_NAME hence the clause : upper(ANALYTIC_PRIVILEGES.USER_NAME) = upper('system') is used but it doesnt work.Anyone has a solution?