Suppose following object privileges on schema _SYS_BI are assigned to user I3110402.
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
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.