Roles tab is used to define the existing roles in HANA system and you can also create a new role in HANA system to add to user’s profile as per requirement.To add privilege to a new role, you have to click on “+” sign.

Users tab defines the list of existing users in HANA system and you can also create a new user, new restricted user or find a user in HANA system.In above pic, you can use Find User to filter a particular user from existing list.

Security tab is used to define different policies in HANA system:AuditingPassword PolicySAML Identity ProvidersData Volume EncryptionTo define an Audit policy, you have to click “+” sign −

Last folder in SAP HANA Studio system navigation is Security and it has 3 subfolders inside it that defines the system security policy and user management activities −SecurityUserRolesIn Security tab, you can also define Password Policy of HANA system.In Users tab, you can find list of all the existing users in SAP HANA system. You can also create a new User or a restricted user in SAP HANA.In Roles tab, you can see all the existing roles in SAP HANA system.

Following are few limitations of using SAP HANA Smart Data Access −Virtual Tables cannot be used in multi node HANA cluster. However, it is possible to access virtual table from one HANA server to other.In SAP HANA, few of Analytical view does not support virtual tables so SDA is not suitable.

Following are major changes are done in SAP HANA SPS07 for Smart Data Access −In later version SPS07, it supports SAP Oracle Database 12c, SAP Sybase Event Stream Processor (ESP) 5.1 SP04 and MSSQL server 2012 version 11 as data sources.In SPS07, it is possible to perform insert/update/deletion for remote databases with some limitations.In SPS06, it was not possible to use BLOB and CLOB data types with virtual tables. In SPS07, SDA now supports BLOBs and CLOBs as column data type of virtual table.SDA has a new feature which will help to check whether SDA installation is done successfully or ... Read More

The database user must assign the corresponding object authorizations to the SAP user −Object privilege: CREATE VIRTUAL TABLE on VIRTUAL_TABLES (SYS)Object privilege: DROP on VIRTUAL_TABLES (SYS)

You need to add SAP HANA system authorization CREATE REMOTE SOURCE to create a remote source. If the remote source is not created with the SAP user but with a different database user instead, then this database user must assign the corresponding object authorizations to the SAP user (CREATE VIRTUAL TABLE and DROP).Navigate to user profile in Security tab and go to System privilege.

Following remote data sources are supported under SAP HANA SPS07 Smart Data Access −SAP HANASybase ASESAP Sybase IQTeradata 13.0 or higherApache Hadoop 2.3MSSQL 11Oracle 12c

With use of SAP HANA SPS06 Smart Data Access, you can only perform Select, Insert, Update and Delete operation on virtual tables moved using new remote data source.