Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

How to Create HANA Database User

In HANA database, user SYSTEM is created automatically when you install it. User SYSTEM is the most powerful user in HANA database, so you don’t want to give it to your IT staff carelessly.

For your information, do not use the SYSTEM user for day-to-day activities. Instead, use this user to create dedicated database users for administrative tasks and to assign privileges to these users. It is recommended that you then deactivate the SYSTEM user, but first you must create another one.

Now, you can create additional database user in HANA for purposes like create queries, procedures, or function using this step by step:

  1. In HANA Studio, right click on your System, expand it, find “Security” folder, and expand it.
  2. Right click on Users, choose “New User”
    Create HANA Database User
  3. On New User window, fill in necessary field, such as username, password, valid from, and valid until.
    Create Database User HANA
  4. On Object Privilege Tab, click “+” button to add which database object(s) you want to grant access to this new user. Database object(s) means database schema, tables, views.In this step, you can grant what kind of operation in selected object(s) to this new user, such as SELECT, CREATE ANY, EXECUTE, etc.
  5. You can click deploy button (F8) to create this new user if you’re done in step 4

 

 

, ,