PT Sterling Tulus Cemerlang



Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

How to Create HANA Database User

Create New 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.

Also read:

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

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: or call +6221-5806336 or wa +6287786555055

, ,