Create a New User and Assign Permissions
2018-08-09
Beginner
10 min.
Create a new TPCH user and assign roles and privileges to the new user.
You will learn
- How to create users in the database (and to create the TPCH schema used throughout the guide).
- How to assign roles and privileges (permissions) to users.
Prerequisites
- System: Access to an SAP HANA 2.0 system with the optional SAP HANA dynamic tiering component installed.
- Credentials: Connection details to initially connect to the tenant database as the tenant
SYSTEM
user. - Access Access to SAP HANA cockpit for the SAP HANA system that data tiering is running on and which you will be working with.
Step 1: Create the TPCH user
Step 2: Assign roles and privileges to the TPCH user
Step 3: Additional information