Symptom
When trying to grant PUBLIC role via HANA Studio with SYSTEM user, you faces below error:
"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 , KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-STD-ADM-SEC , SAP HANA Security & User Management (Studio) , 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.