Solution : https://service.sap.com/sap/support/notes/1605168 (SAP Service marketplace login required)
Summary :
Users updating SAP HANA from Revision 10 or 11 to Revision 12 may encounter model activation issues due to privilege management changes. In Rev 12, objects activated are owned by _SYS_REPO, transitioning privilege management to stored procedures from SAP HANA studio. For existing objects, reactivation post-upgrade is necessary to manage privileges through the UI. This update introduces STRUCTUREDPRIVILEGE ADMIN, allowing specific authorization for privilege management. Scripts using direct GRANT/REVOKE commands must adapt to these stored procedures. Detailed instructions and the necessary SQL commands for applying these changes are provided in SAP's documentation.
Key words :
drop procedure grant_select_on_view create procedure grant_select_on_view, sap hana data base revision 12 solution 1, create structured privilege system privilege, grant/revoke structured privilege <priv>, privilege = 'create structured privilege', sap hana database revision 10, create structured privilege, create procedure revoke_select_on_view, create procedure revoke_analytical_privilege, drop procedure revoke_select_on_view
Related Notes :
| 1604725 | SAP HANA appliance: Revision 12 of SAP HANA database |
| 1523337 | SAP In-Memory Database 1.0: Central Note |
| 1514967 | SAP HANA 1.0: Central Note |