How To Fix SCTS_HDI095 - Error in assignment of read rights on schema &1 for UPS user &2

SCTS_HDI095 - Overview

• Message type: E = Error

• Message class: SCTS_HDI - Messages for CTS HDI API

• Message number: 095

• Message text: Error in assignment of read rights on schema &1 for UPS user &2

What causes this issue?

During the development of HDI objects in SAP Web IDE for SAP HANA for
container &V4& objects of schema &V1& can only be used if the database
user &V2& has read authorization for this schema.

System Response

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

How to fix this error?

Procedure for System Administrators

Grant the ABAP database user &V3& the SELECT and SELECT METADATA
authorizations WITH GRANT OPTION for database schema &V1&.
Then execute the action again that led to this error or start program
SCTS_HTA_ADMIN and execute action <LS>Update References in Projects of
SAP Web IDE</> for container &V4&.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message SCTS_HDI095 - Error in assignment of read rights on schema &1 for UPS user &2 ?

  The SAP error message SCTS_HDI095 indicates that there is an issue with the assignment of read rights on a specific schema for a user in the context of the SAP HANA database, particularly when using the SAP HANA Database Explorer or when working with HDI (HANA Deployment Infrastructure) containers.
  
  Cause:
  This error typically occurs due to one of the following reasons:
  
  
  Insufficient Privileges: The user (UPS user) does not have the necessary privileges to access the specified schema. This can happen if the user has not been granted the appropriate roles or permissions.
  
  
  Schema Ownership: The schema may not be owned by the user or the user may not have been granted access to the schema.
  
  
  
  Configuration Issues: There may be configuration issues in the HDI container or the way the user is set up in the system.
  
  
  
  Solution:
  To resolve the SCTS_HDI095 error, you can follow these steps:
  
  
  Check User Privileges:
  
  Ensure that the UPS user has the