Grant Full Authorization to SAP DB Connection User in SAP HANA Studio

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 Object privileges tab.

    For more information about object privileges, see Object Privileges in the Related Information section below.

  4. Choose Add.
  5. Enter the schema NXI.
  6. Select all the checkboxes in the Privileges for 'NXI' box.
  7. Deploy (F8).
  8. Repeat the steps above to grant the SAP DB Connection user authorization for the schema _SYS_BIC.
Related Information