SAP Knowledge Base Article - Preview

2844763 - Unable to grant the role PUBLIC to an XSA user

Symptom

  • You create a user in the SAP HANA XS Advanced Cockpit.
  • You need this user to access the HANA database but XSA users are not granted the role PUBLIC.
  • When you try to grant role PUBLIC to the XSA user via HANA Studio GUI or the HANA Cockpit you get the following error:

SQL (258) - insufficient privilege: Not authorized to grant role PUBLIC


Read more...

Environment

  • SAP HANA XS Advanced
  • SAP HANA 1.0 SPS12
  • SAP HANA 2.0

Product

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

Keywords

HANA, XSA, role, PUBLIC, insufficient error, HANA Studio, HANA Cockpit, SAP HANA XS Advanced Cockpit , KBA , HAN-DB-DI , SAP HANA DI (HDI): diserver, HDI plugins& client libs , 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.