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

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