- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
System Authorization to use SAP HANA Smart Data Access
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<SID> user but with a different database user instead, then this database user must assign the corresponding object authorizations to the SAP<SID> user (CREATE VIRTUAL TABLE and DROP).
Navigate to user profile in Security tab and go to System privilege.
- Related Articles
- Remote system allowed in SAP HANA Smart Data Access
- Object privilege required to use SAP HANA Smart Data Access
- Connection used in SAP HANA Smart Data Access
- Using Smart Data Access SDA in SAP HANA
- Limitations of using SAP HANA Smart Data Access
- Connecting to MSSQL, MaxDB using SAP HANA Smart Data Access
- Adapters supported under Smart Data Access in SAP HANA
- Content of property_orcl.ini file in SAP HANA Smart Data Access
- Updated features in SAP HANA SPS07 for Smart Data Access
- Different ODBC connection types under SAP HANA Smart data access SDA
- Using SAP HANA SPS06 vs SPS07 with Smart Data Access SDA
- SQL statement to add a table as Virtual table in SAP HANA Smart Data Access
- Data Compression in SAP HANA system
- Authorization concept in SAP system and Profile
- Disabling JDBC/ODBC access to SAP HANA system for a new user

Advertisements