Please note, this is a STATIC archive of website www.tutorialspoint.com from 11 May 2019, cach3.com does not collect or store any user information, there is no "phishing" involved.
Tutorialspoint

SQL statement to create a Restricted user in SAP HANA

In my SAP HANA environment, I have created a restricted user using HANA Studio UI option. Can someone help me with SQL query to create restricted user?


1 Answer
SAP Expert

It is very simple. You can create a Restricted user with below query:

CREATE [RESTRICTED] USER <user_name>
   [<remote_identity_option>]
   [<password_option> ]
   [<external_ident> ]
   [<with_ident_opts> ]
   [<validity_specification> ]
   [<set_user_parameters> ]
   [<ldap_group_authorization>]

In above SQL query, you have to pass following parameters:

<remote_identity_option>

Specifies a database user in another tenant database as the remote identity of the database user being created.

<password_option>

Specifies the user password of the user being created.

<external_ident>

Defines an external identification mechanism.

<external_identity>

Defines an external identity that is used to authenticate the user.

Advertisements

We use cookies to provide and improve our services. By using our site, you consent to our Cookies Policy.