Unable to create the stored procedure or function in UCCX database db_cra

[Vinod Patil]

Hi Experts,

I'm trying to create the stored procedure or function in UCCX database db_cra for custom reports. Connected to the database using the RazorSQL tool with login Id as uccxhrc When tried to execute the SP(see in the attachment the SP_test) , it will give an error ERROR: No resource permission. Error Code: -388 (see the attachment) Also tried with statement " GRANT EXECUTE ON PROCEDURE test2 TO uccxhrc; " in SP but no luck. Could you please help me grant permission to create SP? Regards, Vinod

[Deepak Rawat · Accepted solution]

Vinod,

Correct syntax is

grant execute on<your procedure name> to 'uccxHrUserRole';

Also, try using the uccxhruser username and password instead of uccxhrc as mentioned in the Cisco Unified Contact Center Express Report Developer Guide.

Regards

Deepak

- Rate Helpful Posts -

[Vinod Patil]

Thanks Deepak, no need of grant execute statement, its working with uccxhruser