PT Sterling Tulus Cemerlang
www.sterling-team.com

Whatsapp
+62-877-8655-5055

Email
sales-enquiry@sterling-team.com

Address
Ruko Graha Arteri Mas Kav 30
Jl. Panjang No.68, RT.19/RW.4
Kedoya Selatan, Kebon Jeruk
Kota Jakarta Barat
Jakarta, 11520 Indonesia

500+ FREE Tips for you from Sterling Tulus Cemerlang (STEM) - SAP Indonesia Gold Partner, and Become SAP B1 Super User

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, SAP Business One GOLD Partner in Indonesia.
More details about SAP Business One,
email to: sales-enquiry@sterling-team.com or call +6221-5806336 or wa +6287786555055

, ,