2795522 - Querying EFFECTIVE_ROLE_GRANTEES fails with error unknown role_name

• 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: [500]: 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