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
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.
SAP Knowledge Base Article - Preview