SAP Knowledge Base Article - Preview

2791451 - Repository roles stop working after objects referenced in their definition are recreated.


  • You have a repository role that grants some privilege for a table or a view.
  • The table/view is dropped and then created again.
  • Some users with the role assigned get "insufficient privilege: Not authorized" errors when trying to access the table/view.



  • SAP HANA 1.0
  • SAP HANA 2.0


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


Role, catalog, object, repository, table, view, drop, regenerate , KBA , HAN-DB-SEC , SAP HANA Security & User Management , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , 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.