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.