User Types in SAP HANA Database | Techrelam

 

User Types in SAP HANA Database

There are two types of User in SAP HANA database.

1. Standard User
2. Restricted User

Standard users can create objects in their own schema and read data in system views. The PUBLIC role grants read access to system views, and this is granted to every standard user. Restricted users initially have no privileges. 

Restricted users are for users who access SAP HANA through client applications and who do not have full SQL access through an SQL console. If the privileges that they need to use the application are included within an application-specific role, then you only have to grant the user this role. In this way, you can ensure that users only have those privileges that are essential to their work.

Limitations of Restricted Users 

Compared to standard database users, restricted users are initially limited in the following ways:

They cannot create objects in the database because they are not authorized to create objects in their own database schema. 

They cannot view any data in the database because they are not granted (and cannot be granted) the standard PUBLIC role. 

They are only able to connect to the database using HTTP/HTTPS. 

To enable a restricted user to use an application, grant the required application-specific roles. Initially, restricted users can only connect to the database using HTTP or HTTPS.

To allow restricted users to connect through ODBC or JDBC, enable ODBC or JDBC access explicitly.