SQL statement to create a Restricted user in SAP HANA

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.

SAP Expert

Updated on: 27-Feb-2020

283 Views

Kickstart Your Career

Get certified by completing the course

Get Started