SAP Knowledge Base Article - Preview

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

Symptom

  • 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.


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

Role, catalog, object, repository, table, view, drop, regenerate , Repository roles stop working after objects referenced in their definition are recreated.,Repository roles stop working , Repository Roles,SYS.EFFECTIVE_ROLES, invalid table name,role <package>::<role_name> ,call grant_activated_role ('<package>::<role_name>', '<user>') , grant_activated_role , 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.