Skip to Content
0

[HANA] SCHEMA_NAME field with value " ? "

Jan 31, 2017 at 05:35 PM

37

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Jan 31, 2017 at 07:57 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded