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: : predicates are required in a where clause: ... needs predicates on columns (connected by AND if more than one)
SAP HANA, platform edition
SAP HANA, platform edition all versions
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 pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.