Found 694 Articles for SAP HANA

This can be created using following SQL query −CREATE USER TEST_122 PASSWORD Pass123$$

It is very simple. You can create a Restricted user with below query −CREATE [RESTRICTED] USER    []    [ ]    [ ]    [ ]    [ ]    [ ]    []In above SQL query, you have to pass following parameters −Specifies a database user in another tenant database as the remote identity of the database user being created.Specifies the user password of the user being created.Defines an external identification mechanism.Defines an external identity that is used to authenticate the user.

It is not possible to add PUBLIC profile to a restricted user. When a restricted user is created, it doesn’t have PUBLIC profile.

When you compare standard database users, restricted users have the following limitations −With restricted users, it is not possible to create objects in the database as they are not authorized to create objects in their own database schemaRestricted users are not authorized to view any data in the database as they are not granted the standard PUBLIC roleWith the use of restricted users, you can connect to the database using HTTP.

You can create a restricted user by navigating to Security tab → UsersWhen you select New Restricted User option, it will open New user creation window, and you have to pass the details as requested.

Following are the key limitations that HANA overcomes −As data size is growing it is a big problem for companies to store huge amounts of data. You talk about any industry domain- healthcare, FMCG, Banking, and Insurance, as subscribers are increasing there is an increase in historical data with time. SAP HANA Column base storage allows data compression and hence reducing the cost of storing the data.As data size is growing it is a huge problem for companies to maintain and analyze the historical data. A conventional database doesn’t provide a mechanism to process large volumes of data. With an ... Read More

SSO can be configured on below authentication methods −SAMLKerberosX.509 client certificates for HTTP access from HANA XS engineSAP Logon/Assertion tickets

When you create a new user, you need to select checkbox- Disable ODBC/JDBC access −

At the time of user creation, you have an option to pass Valid From and Valid Until date.

Below is the list of authentication methods supported by SAP HANA −User name/PasswordKerberosSAML 2.0SAP Logon ticketsX.509You can configure any of authentication method while creating a new user −