Assign System Privileges to SAP DB Connection User (Optional)

Context

Grant the following system privileges to the SAP DB connection user in the SAP HANA database if you intend to use the following:
  1. A virtual table or/view using the HANA SDA function type in the model view
    • CATALOG READ
    • CREATE REMOTE SOURCE
    • DATA ADMIN
  2. File Adapter function
    • IMPORT
    • EXPORT
  3. SAP HANA R Script function type in the remote function adapter
    • CREATE R SCRIPT

Procedure

  1. Log on to the SAP HANA database of your system within SAP HANA Studio.
  2. In the Security folder, open the database connection user (database connection user maintained while creating the database connection DBCON).
  3. Go to the System Privileges tab.
  4. Choose Add.
  5. Enter the following system privileges:
    • CATALOG READ
    • CREATE REMOTE SOURCE
    • DATA ADMIN
    • IMPORT
    • EXPORT
    • CREATE R SCRIPT
  6. Deploy (F8).