You want to execute a query to another schema by using the transaction code DB02, SQL Editor. The query is failed due to below error,
Missing HANA Privilege of DB User SAPABAP1
insufficient privilege: Not authorized
If you double click on the red box icon above, you will get some details on the error,
Exception CX_DBA_ADBC in class CL_HDB_SQL_EXECUTOR method EXEC_QUERY_DYN line 155
Kernel Error ID:
WP ID: 0
WP PID: 4476
Application Server: KEEM_SERVER1
SYSID: EX1
SY-SUBRC: 0
SQL statement: SELECT * FROM “ITSITI”.”DAANI”
Database: DEFAULT
caused by
Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
Kernel Error ID:
DB Error: Yes
SQL Code: 258
SQL Message: insufficient privilege: Not authorized
DB Object Exists: No
Duplicated Key: No
Internal Error: 1
Invalid Cursor: No
Unknown Connection: No
Connection Closed: No
Solution
In this case, the database is on SAP HANA and the schema is SAPABAP1.
Since you are executing to another schema (not the SAPABAP1), you must assign the schema owner of SAPABAP1, which is SAPABAP1 user the Object Privileges of the target schema in HANA Studio.
Now, login to the SAP HANA Studio with the user that having the HANA user administration role. Click on Security and search / filter the SAPABAP1 user. Double click on the SAPABAP1 user.
On the right panel, you will get the property details of SAPABAP1 user. Jump to Object Privileges tab and click the + icon. Search for the schema name ITSITI and click OK to assign it.
Depending on your requirement, define the privileges required for SAPABAP1 user to ITSITI schema. For us, we only need SELECT statement enabled.
Once done, click on F8 (Deploy) to confirm the changes. You can try to execute the query again! It should be work fine now.
