12-09-2015 12:39 PM - edited 03-14-2019 03:32 PM
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
Solved! Go to Solution.
12-09-2015 11:02 PM
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 -
12-09-2015 11:02 PM
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 -
12-10-2015 01:35 AM
Thanks Deepak, no need of grant execute statement, its working with uccxhruser
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide