SAP Knowledge Base Article - Preview

3587308 - Removal of System Privilege for Custom Repository Roles in HANA DB

Symptom

  • The issue arises when attempting to remove a system privilege, for example DATA ADMIN from custom repository roles in HANA DB.
  • The SQL command to revoke the privilege appears to execute successfully, but the system privilege remains intact.


Read more...

Environment

SAP HANA Security & User Management

Keywords

HANA DB, DATA ADMIN, privilege, custom roles, _SYS_REPO, repository-based roles, HANA Web IDE, HANA Studio, role definition, .hdbrole, activate role. , KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.