Are you wondering what the best way is to manage changing data structures? Do you want to know how to collaborate more efficiently when working in development projects?
To answer the first question, learn what benefits different table types in SAP HANA Cloud, SAP HANA database can offer you based on your needs. The following 3 tutorials in this tutorial group will help you navigate through your challenges with the managing data structures:
Get started to collaborate in SAP Business Application Studio
Import data into a table in SAP HANA Database Project
Change data structures using HDBTABLE and HDBMIGRATIONTABLE objects
To answer the second question, create template projects that help you set up service connections, handle synonyms and prepare authorization management. You can create these templates once in the beginning and give your project team members a head-start. Using the template, they can build on your work and can quickly start working productively. The following 4 tutorials in this tutorial group will help you learn how to collaborate efficiently:
Prepare your SAP HANA Database Project for collaboration
Generate users and roles for assigning privileges
You are here ☛Enhance your project with services, synonyms and grants
Collaborate on an SAP HANA Database Project template
This tutorial will show you how to enhance your project with services, synonyms, and grants.
Step 1Create a User-Provided Service in SAP Business Application Studio
—
The user-provided service will be responsible for granting privileges to the project in the future.
Go back to your SAP Business Application Studio tab and to your project WS3_3. If it is not open already, you can find it on the Welcome screen.
Navigate to the explorer if you are still in the source control view. You can get there by clicking on the File Explorer icon at the top of the vertical menu bar on the left of the screen.
On the bottom left corner, you can see the project folder WS3_3/db in the SAP HANA Projects panel. Click on the deploy icon for the file to deploy the changes to your HDI container.
Next, click on the plus icon for adding database connections.
Add database connection
The Add Database Connections window will open.
In the field Select connection type, select Create a user-provided service instance from the drop-down menu.
Create UPS instance
Enter the name of the service instance as UPS_GENERIC.
Under Connect to database, select Use deployment target container database.
Under Enter username, enter UPS_GRANTOR.
Under Enter password, enter the password DnATBG!1 that you used while creating the user in the SAP HANA Database Explorer using SQL.
Click on Add to complete the creation of the user-provided service instance. You will see this addition in the SAP HANA PROJECTS panel.
UPS instance view
Step 2Grant privileges using user-provided service
+
Select the src folder from the explorer. Press the F1 key or click on View – Find Command at the top of the screen to open a prompt. Enter HANA in the field and from the dropdown list of functionalities, choose SAP HANA: Create SAP HANA Database Artifact.
In the window for creating a new SAP HANA Database Artifact, click on theFolder Iconfolder icon in the first field (“Choose path where you want to create the artifact”). Navigate to your project, the src folder, and then click on Open.
Select the artifact type as Grants (hdbgrants).
In the field Specify the artifact name, enter the name generic.
The database version should be HANA Cloud, by default. Without making any further changes, click on Create.
A new file generic.hdbgrants can be seen in the src folder in the File Explorer. Click on this file to open the file window.
The hdbgrants file comes pre-filled with templates you can use. In this session, we will only need to grant global roles to object owners and application users. Below you can see the code needed to do that. Remove all the default code and copy and paste the code below to the generic.hdbgrants file.
8. Click on the deploy icon for the file. You can do this either from the SAP HANA Projects panel or from the deploy icon on the top right corner of the file window.
After successful deployment of the `generic.hdbgrants` file, object owner users and application users will be authorized to report on the data in the container.
### Create a synonym
Next, you will create a synonym that allows users of the template project to access the inventory table even if they do not have it present in their own HDI container.
1. Right-click on the `src` folder and select **New File**.
2. Name the file as `generic.hdbsynonym`. Click **OK**.
3. A new file named `generic.hdbsynonym` will be visible under the `src` folder. Select the file to open the window.
4. Click on **Click to Add** to add a new synonym.
5. Click on the new synonym created under the column Synonym Name and rename it as `SInventory`.
6. In the **Object Name** column, click on the **three dots icon** to search for the object.
7. A new dialog **Find Data Sources** will open. Make sure to select `UPS_GENERIC` in the services filter.
8. Type `**` in the search bar to view the list of all objects available. Double-click on the object `INVENTORY` contained in the schema used in the first session of this workshop series.
9. Select the synonym `SInventory`.
> The Schema Name column should have the appropriate schema of the object by default (in this case, `WS3_1_HDI_DB_1`). Make sure this matches the name of your container. If this is not the case for you, please add the name of the schema you obtained in step 7 (sub-step 5) of the tutorial "[Generate users and roles for assigning privileges](hana-cloud-collaborative-database-development-5)".
10. Click on the **deploy icon** to deploy this synonym.
### Verify the data present in the synonym
1. You can check if your synonym was successfully deployed to your database by opening your HDI container icon from the SAP HANA Projects panel.
2. In the SAP HANA Database Explorer select your HDI container from the list of database connections.
3. In the catalog, scroll down to **Synonyms**, clicking on it should reveal the synonym `SInventory`.
4. Right-click on `SInventory` seen at bottom left-side explorer panel and then select **Open Data**.
You will now view the data present in the INVENTORY table created in the [second tutorial](hana-cloud-collaborative-database-development-2).
And with that, your template project is already done and ready for collaborators to use. Before you can give others access to this project, you will need to synchronize your project with your git repository.
> You have successfully completed this tutorial. In the next tutorial, you will see how to collaborate on the template project you created previously.
### Test yourself
---
</div><div class="step-validation-mount"
data-step="2"></div>
<div class="step-actions">
<button class="fd-button fd-button--emphasized" data-action="mark-done" data-step="2">Done</button>
</div>
</div>
</div>
Share feedback on this tutorial or join the conversation in SAP Community.
Submit detailed feedbackDiscuss in Community
Steps
Step 1 of 2
1. Create a User-Provided Service in SAP Business Application Studio2. Grant privileges using user-provided service
Joule
AI Notice
Joule is an AI assistant. Generative AI may produce inaccurate, incomplete, or biased information. Always verify important details before acting on them.
Conversations are sent to SAP-hosted large language models for processing. Do not include personal data, credentials, or confidential information in your messages.
Joule's responses are based on the SAP tutorial catalog and may not reflect the latest product changes. For authoritative guidance, consult the linked tutorials and official SAP documentation.
