- You are querying the System View EFFECTIVE_ROLE_GRANTEES, using an equal predicate on column ROLE_NAME.
- The query looks similar to the following:
SELECT * FROM EFFECTIVE_ROLE_GRANTEES WHERE ROLE_NAME = '<ROLE_NAME>';
- The '<ROLE_NAME>' in question does not exist in ROLES System View;
- The query fails with the following error:
SAP DBTech JDBC: : predicates are required in a where clause: unknown role_name
SAP HANA, platform edition 2.0
role_nam, unknown, querying, EFFECTIVE_ROLE_GRANTEES, views , KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem
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.