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

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)

SAP HANA, platform edition

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