Skip to Content
avatar image
Former Member

[HANA] SCHEMA_NAME field with value " ? "

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 31, 2017 at 07:57 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded