SAP Knowledge Base Article - Preview

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

Symptom

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

-CREATE ANY

-DROP

-EXECUTE

-SELECT

1.png

 

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

2.png

 

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.

3.png

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


Read more...

Environment

SAP HANA Platform Edition 2.0 or higher

Product

SAP HANA, platform edition 2.0

Keywords

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 page

This 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.