getting insufficient privilege issue while creating p...

[#1]

While trying to create a procedure in Datashere database explorere , getting error like - Could not execute 'CREATE PROCEDURE sp_load_0hr_pa_1 ( ) AS BEGIN MERGE INTO "DEV"."0HR_PA_1_Final" AS T ...'
Error: (dberror) [258]: insufficient privilege: Detailed info for this error can be found with guid 'C0119EE67068C04B96D3FE4052A3A834' 

user used for login  to DB explorer - DWCDBUSER#DB_USER

__PRESENT

[Joana6]

Hello,

For insights on managing privileges in the database explorer, you can refer to the help page at  https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/d26bddb8bba54e2eac09d85... . This resource provides guidance on identifying the missing privileges for the specified user. After granting the identified privilege, if there are further privileges needed, simply run the procedure again using the GUID from the new error message for continued troubleshooting.

Best regards,
Joana