SAP Knowledge Base Article - Preview

2748386 - Error "SAP DBTech JDBC: [500]: predicates are required in a where clause" When Running Select * From User Authorization Views

Symptom

You execute a statement on user authorization views like ACCESSIBLE_VIEWS, EFFECTIVE_APPLICATION_PRIVILEGES, and so on, directly without defining WHERE conditions. For example:

"SELECT * FROM "PUBLIC"."ACCESSIBLE_VIEWS";

It fails with the similar error:

SAP DBTech JDBC: [500]: predicates are required in a where clause: ... needs predicates on columns (connected by AND if more than one)


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

ACCESSIBLE_VIEWS, EFFECTIVE_APPLICATION_PRIVILEGES, EFFECTIVE_MASK_EXPRESSIONS, EFFECTIVE_PRIVILEGE_GRANTEES, EFFECTIVE_PRIVILEGES, EFFECTIVE_ROLE_GRANTEES, EFFECTIVE_ROLES, EFFECTIVE_STRUCTURED_PRIVILEGES, equal, predicate, needs, predicates, column, columns, authorization, permission, error , KBA , HAN-DB-ENG , SAP HANA DB Engines , HAN-DB-SEC , SAP HANA Security & User Management , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.