/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
Activating a HANA Repository role (.hdbrole) fails with an "insufficient privilege" error.
Diagnostic output from SYS.GET_INSUFFICIENT_PRIVILEGE_ERROR_DETAILS shows _SYS_REPO is missing GRANT OPTION for EXECUTE on the _SYS_AFL schema.
This KBA will tell you how to grant EXECUTE WITH GRANT OPTION on _SYS_AFL Schema.
Read more...
Environment
- SAP HANA 1.0
- SAP HANA 2.0
Product
SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0
Keywords
repository role, role activation, schema browsing, _sys_repo, _sys_afl, AFL__SYS_AFL_ERPA_EXECUTE_WITH_GRANT_OPTION, execute with grant option, hana repository, role modify, activation fails, schema privilege, repository privileges, hana security, user management, grant option , 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.
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)