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

SAP Error Message - Details

• 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 necessary privileges to access the schema. You can do this by checking the roles assigned to the user in the SAP HANA database.
  You may need to grant the user the appropriate roles or permissions. For example, you can use SQL commands to grant read access:
  GRANT SELECT ON SCHEMA <schema_name> TO <user_name>;
  
  
  
  
  Verify Schema Ownership:
  
  Check if the schema is owned by the correct user or if the UPS user has been granted access to it. If the schema is owned by another user, you may need to adjust the permissions accordingly.
  
  
  
  Review HDI Container Configuration:
  
  Ensure that the HDI container is correctly configured and that the user is properly set up within the container. You may need to check the HDI deployment settings and ensure that the user is included in the necessary roles.
  
  
  
  Consult Documentation:
  
  Refer to the SAP HANA documentation for more details on user management and permissions related to HDI containers.
  
  
  
  Contact Support:
  
  If the issue persists after checking the above points, consider reaching out to SAP support for further assistance.
  
  
  
  Related Information:
  
  SAP HANA Security: Understanding user roles and privileges in SAP HANA is crucial for managing access to schemas and data.
  HDI Containers: Familiarize yourself with the concept of HDI containers and how they manage database objects and user access.
  SAP Notes: Check for any relevant SAP Notes that may address known issues or provide additional guidance on this error.
  
  By following these steps, you should be able to resolve the SCTS_HDI095 error and ensure that the UPS user has the necessary access rights to the specified schema.