getting insufficient privilege issue while creating procedure in database explorer of datasphere

[#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

[cardoso]

Hello @gosapckg30,

I think DB Analysis Users (with prefix DWCDBUSER#) are not intended for creating procedures.
Instead, try using an OpenSQL schema (SPACE_TECH_NAME#DB_USER_NAME) to create a procedure inside the OpenSQL Schema. 
Creating procedures on a Space's schema is not allowed as far as I know.

BR.

[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