Solution : https://service.sap.com/sap/support/notes/1612696 (SAP Service marketplace login required)
Summary :
Errors may arise when executing selects or data previews in analytic views post-activation, signaled by the error message indicating an invalidated view at a specific script location. The issue likely stems from inadequate permissions. The _SYS_REPO user, and potentially other users, require SELECT permissions on all involved schemata with the GRANT option. In SAP HANA Studio, this can be addressed by navigating to Authorization > Users > _SYS_REPO > SQL Privileges and adjusting settings. Alternatively, execute SQL commands to grant the necessary permissions directly. Ensuring these permissions are correctly configured is crucial for normal view functionality.
Key words :
authorization > users > _sys_repo > sql privileges, choose add catalog object, _sys_repo user select permissions, ' sap dbtech jdbc, _sys_repo user, sql statement, select permissions, missing permissions, execute 'select, check select
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 |