How To Fix ESH_SQL_SEARCH036 - No access to ESH procedure SYS.ESH_SEARCH

SAP Error Message - Details

• Message type: E = Error

• Message class: ESH_SQL_SEARCH - ESH SQL Search

• Message number: 036

• Message text: No access to ESH procedure SYS.ESH_SEARCH

What causes this issue?

The technical user has no authorizations to execute in HANA the Stored
Procedure "SYS.ESH_SEARCH".

System Response

The search cannot be executed.

How to fix this error?

For missing authorizations for search in CDS-views consider the link:
https://wiki.wdf.sap.corp/wiki/display/HDBSearch/System+Setup+for+ABAP+C
DS+Search

Procedure for System Administrators

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message ESH_SQL_SEARCH036 - No access to ESH procedure SYS.ESH_SEARCH ?

  The SAP error message ESH_SQL_SEARCH036 indicates that there is no access to the ESH (Enterprise Search) procedure SYS.ESH_SEARCH. This error typically arises when a user or a role does not have the necessary authorizations to execute the ESH search functionality.
  
  Cause:
  
  Authorization Issues: The user executing the search does not have the required authorizations to access the ESH procedure.
  Missing Roles: The user may not be assigned the necessary roles that include the required permissions for ESH.
  Database Permissions: There may be restrictions at the database level that prevent access to the ESH procedures.
  
  
  Solution:
  
  
  Check User Authorizations:
  
  Use transaction code SU53 immediately after the error occurs to check for missing authorizations.
  Review the authorization objects related to ESH, such as S_RFC, S_DEVELOP, and any specific ESH-related authorization objects.
  
  
  
  Assign Required Roles:
  
  Ensure that the user has been assigned the appropriate roles that include access to ESH functionalities. Common roles include:
  SAP_BC_ESH_ADMIN
  SAP_BC_ESH_USER
  
  
  You can check and assign roles using transaction code PFCG.
  
  
  
  Database