Add user in HANA DB

[Former Member]

How do I add an user in the HANA DB

The Admin Guide (Page 34) mentions

" Select Authorization in the Navigator"

but I dont seem to see the context menu "authorization" in the Navigator . My intension is to create a user with modeling capabilities .

[Former Member · Accepted solution]

"Authorization" is not a context menu item, it's a node in the Navigator tree. Expand your system connection node, then "Content", then "Authorization". Now you can right-click "Users" to create a new user.

Alternatively, you can run SQL to create a new user with modeling authorizations::

CREATE USER my_user PASSWORD My_Password;
GRANT MODELING TO my_user;

(up to revision 18, it would have been:

CREATE USER my_user IDENTIFIED BY My_Password;
GRANT MODELING TO my_user;

)

--juergen

[Former Member · Accepted solution]

Yes , I had found the authorization node later . But thanks for the showing the SQL way of creating a user .

[Former Member · Accepted solution]

Yes , I had found the authorization node later . But thanks for the showing the SQL way of creating a user . Made me realise that HANA SQL is like any other SQL like microsoft SQL and can just about do anything

[Former Member · Accepted solution]

yes, the follow standard ANSI SQL* Syntax. that is common for database standards.