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
[ACCORDION-BEGIN [Step 1: ](Access the Security Console)]
26
+
25
27
From the ***SAP HANA Cockpit*** and connected with the ***HANA System Account***, click on **Manage Roles and Users**. This will open the ***SAP HANA Web-based Development Workbench***.
26
28
27
29
28
30
31
+
[DONE]
29
32
[ACCORDION-END]
30
33
31
34
[ACCORDION-BEGIN [Step 2: ](Extend the SYSTEM user)]
@@ -42,6 +45,7 @@ Select the **Granted Roles** tab, then click on the  icon, th
42
45
43
46
Click on the  button in the top menu bar
44
47
48
+
[DONE]
45
49
[ACCORDION-END]
46
50
47
51
[ACCORDION-BEGIN [Step 3: ](Create your user)]
@@ -80,10 +84,11 @@ GRANT REPO.ACTIVATE_IMPORTED_OBJECTS on "public" TO PSTRIAL;
80
84
81
85
**This script will delete any existing `PSTRIAL` user including its related object and tables.**
82
86
83
-
Click on the **Run** button or press **F8**.
87
+
Click on the **Run** button or press **F8**.
84
88
85
89
86
90
91
+
[DONE]
87
92
[ACCORDION-END]
88
93
89
94
[ACCORDION-BEGIN [Step 4: ](Verify that your user is properly created)]
@@ -96,8 +101,19 @@ Now, you need to connect with your **`PSTRIAL`** ***HANA User Account***.
96
101
97
102
Enter **`PSTRIAL`** as ***Username*** user name and **`Welcome18Welcome18`** as ***Password***, click on **Logon**.
98
103
99
-
If you can login, then your ***HANA User Account*** is properly configured.
104
+
You can now verify that the roles where properly granted.
105
+
106
+
Click on the  button in the top menu bar, and paste the following SQL code:
107
+
108
+
```sql
109
+
SELECT*FROMSYS.GRANTED_ROLES;
110
+
```
111
+
112
+
Click on the **Run** button or press **F8**.
113
+
114
+
Provide an answer to the question below then click on **Validate**.
@@ -32,11 +33,11 @@ Make sure you check the [LICENSE](https://github.com/SAPDocuments/Tutorials/blob
32
33
33
34
During this tutorial series, you will be able to address multiple services using different datasets.
34
35
35
-
We could have used the HANA Studio import feature, but this would assume that you have it installed.
36
+
You could have used the HANA Studio import feature, but this would assume that you have it installed.
36
37
37
38
Due to restrictions related to the resources, format and size that can be made available on the tutorial platform, it was required to split some of the data into several chunks.
38
39
39
-
But first we need to create the tables.
40
+
But first you need to create the tables.
40
41
41
42
Open the ***SAP HANA Web-based Development Workbench*** on your trial HANA instance connected as **`PSTRIAL`**, click on **Catalog**.
42
43
@@ -58,6 +59,7 @@ A **`PSDEMO`** schema should appear in the list.
58
59
59
60
60
61
62
+
[DONE]
61
63
[ACCORDION-END]
62
64
63
65
[ACCORDION-BEGIN [Step 2: ](Import the dataset)]
@@ -98,6 +100,28 @@ Click on the **Run**  button or press F8.
98
100
99
101
100
102
103
+
[DONE]
104
+
[ACCORDION-END]
105
+
106
+
[ACCORDION-BEGIN [Step 3: ](Verify the imported dataset)]
107
+
108
+
You can now verify that the datasets where properly imported.
109
+
110
+
Click on the  button in the top menu bar, and paste the following SQL code:
111
+
112
+
```sql
113
+
SELECT'Census'as TABLE, COUNT(1) FROM PSDEMO."Census"
114
+
UNION
115
+
SELECT'CashFlow'as TABLE, COUNT(1) FROM PSDEMO."CashFlow"
116
+
UNION
117
+
SELECT'Transactions'as TABLE, COUNT(1) FROM PSDEMO."Transactions"
118
+
```
119
+
120
+
Click on the **Run** button or press **F8**.
121
+
122
+
Provide an answer to the question below then click on **Validate**
0 commit comments