Database error 258 at EXE

Updated May 18, 2018

Hello SAP Experts,

A newly created database user in the Solution Manager has been granted access to the PUBLIC and MONITORING roles. But the Solution Manager gives the following errors:

Database error 258 at EXE
Insufficient privilege: Not authorized

Comments

21 Nov 2016 1:55 pm Sonia Barwar Best Answer
The error mentioned by you generally occurs when the HANA Database runs with an embedded statistics server. Therefore, in this case, the role MONITORING is insufficient to run the SAP HANA procedures which collect the monitoring information from solution manager.
Therefore the SAP Solution Manager database user requires additional rights in order to execute the necessary procedures in the _SYS_STATISTICS schema.
Please grant below-mentioned rights to the User:
1. GRANT EXECUTE ON SCHEMA _SYS_STATISTICS TO <USER>
2. GRANT UPDATE ON _SYS_STATISTICS.STATISTICS_SCHEDULE to <USER>â€‹