[HANA] SCHEMA_NAME field with value " ? "

[Former Member]

Hi,

I need to analyze privileges of some users in the Hana DB.

Why when I run: "SELECT * FROM SYS_GRANTED_ROLES" in the Hana DB, the SCHEMA_NAME field appears with multiple results (rows) with the value " ? " ?

Tks.

[pfefferf]

You mean the column GRANTEE_SCHEMA_NAME of view SYS.GRANTED_ROLES? The question mark means that it is a null value. If e.g. the grantee is a role (-> e.g. a role is granted to another role), then the grantee schema name is null, cause the role has no schema.