In order to add roles and privileges, make sure you are still connected to the HANA system as the “SYSTEM” user. In the same TPCH user window you just added the new user, go to the Granted Roles tab on the bottom. Click the green plus sign to add new roles.
In the new window that popped up, search and add all the roles listed below. If you want to select multiple roles while the window is open, hold Ctrl and click on the desired roles to be added. Click OK after you are done.
AFLPM_CREATOR_ERASER_EXECUTE
CONTENT_ADMIN
MODELING
sap.hana.uis.db::SITE_DESIGNER
sap.hana.uis.db::SITE_USER
Now go to the System Privileges tab and click on the green plus sign to add new privileges. Add the listed privileges the same way you did for the roles.
EXTENDED STORAGE ADMIN
IMPORT
CATALOG READ
In the roles and privileges tabs on the bottom, double check that you have all the items listed below.
- Granted Roles
AFLPM_CREATOR_ERASER_EXECUTE
CONTENT_ADMIN
MODELING
PUBLIC
(Automatically granted when the TPCH
user is created)
sap.hana.uis.db::SITE_DESIGNER
sap.hana.uis.db::SITE_USER
- System Privileges
EXTENDED STORAGE ADMIN
IMPORT
CATALOG READ
- Object Privileges
TPCH
(automatically granted when user is created)
In order to save the changes you made, press the green Deploy button on the top right. You can also press F8. You will receive a confirmation message at the top of the tab indicating that the TPCH
user has been changed.
