SAP Knowledge Base Article - Preview

3562577 - How to grant or revoke PUBLIC role for users

Symptom

When trying to grant PUBLIC role via HANA Studio with SYSTEM user, error appears:

"Could not modify user '<user_name>'. Could not grant role PUBLIC You are not authorized to perform the required actions"

Note: By default, the "PUBLIC" role is automatically assigned when a Technical user is created. This KBA is relevant if the role was accidentally deleted or if you need to assign it to a database user, such as a Schema user, who does not currently have it. 

"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 1.0
  • SAP HANA Platform Edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

PUBLIC, public role, Grant, revoke, HANA Studio, Could not grant role PUBLIC, You are not authorized to perform the required actions, delete, alter user , KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-STD-ADM-SEC , SAP HANA Security & User Management (Studio) , How To

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.