You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: tutorials/hana-cloud-mission-trial-9/hana-cloud-mission-trial-9.md
+6-10Lines changed: 6 additions & 10 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -190,31 +190,27 @@ After you are done, deploy the whole project again. When that is completed succe
190
190
191
191
Now that you have the role created and granted privileges to this role, it's time to grant this role to a user. We will create the public user `report` that shall have read-only access to the calculation view.
192
192
193
-
1. Go back to your tab with the **SAP HANA Database Explorer** open or click on the HDI container icon () in the SAP HANA Projects panel.
193
+
1. Go back to your tab with the **SAP HANA Database Explorer** and open a SQL Console by clicking on the SQL icon () at the top left corner. Make sure that the connection is opened for an user that has system privileges `ROLE ADMIN` and `USER ADMIN`, e.g., database user `DBADMIN`.
194
194
195
-
2. Open a SQL Console by clicking on the SQL icon () at the top left corner.
196
-
197
-
!
198
-
199
-
3. Paste the following statement in the SQL Console. Change the password in the statement and then run.
195
+
2. Paste the following statement in the SQL Console. Change the password in the statement and then run.
200
196
201
197
```SQL
202
198
CREATE USER report PASSWORD <your_password> NO FORCE_FIRST_PASSWORD_CHANGE set usergroup default;
203
199
```
204
200
205
201
> Using the clause `NO FORCE_FIRST_PASSWORD_CHANGE` is not considered a security best practice! We will only use this option for the purpose of this tutorial, in our example to make a user available to multiple individuals. If you create users in your productive environment, please consider forcing a password change for the first log in and giving individuals different users.
206
202
207
-
4. Now that our new user `report` is created, we need to grant the user access to the role `PublicAccessSchema`.
203
+
3. Now that our new user `report` is created, we need to grant the user access to the role `PublicAccessSchema`.
208
204
209
-
5. Use the following statement.
205
+
4. Use the following statement.
210
206
211
207
```SQL
212
208
GRANT <SCHEMA_NAME>."PublicAccessSchema" to report;
213
209
```
214
210
215
-
6. Replace the `<schema name>` with the calculation view schema you copied in the beginning of this tutorial.
211
+
5. Replace the `<schema name>` with the calculation view schema you copied in the beginning of this tutorial.
216
212
217
-
7. Make sure to remove the `<>` characters and then run the statement.
213
+
6. Make sure to remove the `<>` characters and then run the statement.
0 commit comments