3046046 - How-To: Delete object privileges on schema _SYS_BI/_SYS_BIC with SQL command

This document is mainly used in situation when you want to delete these object privileges via SQL commands.

Suppose following object privileges on schema _SYS_BI are assigned to user I3110402.

-CREATE ANY

-DROP

-EXECUTE

-SELECT

In HANA studio -> Security -> Users, open user I3110402, you are able to delete object privileges _SYS_BI with logon user SYSTEM.

Besides that, you also want to know how to delete these object privileges via SQL commands.

You tried to execute REVOKE commands below, but these object privileges cannot be deleted.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP HANA Platform Edition 2.0 or higher

HANA, object privilege, schema, _SYS_BI, _SYS_BIC, _SYS_REPO, revoke, REVOKE, SQL , KBA , HAN-DB-SEC , SAP HANA Security & User Management , How To