ERROR on execute stored procedure

[Pablo Rabago]

Hi all.

when I try to run an SP (Stored procedure) through a SQL Statement based on data base from iProcess always get the same runtime error message:

 

SQL Statement:

GO

DECLARE @return_value int

EXEC @return_value = [swpro].[sw_jumpto_multi] @proc_name = N'PRC05G', @proc_maj_ver = -1, @proc_min_ver = -1, @withdraw_step = N'SBFASE01', @step_name = N'SETSUBF1', @case_num = 712, @reason = N'Salto', @user_id = N'swadmin'

SELECT 'Return Value' = @return_value

GO

 

Result:

 

Mens 229, Nivel 14, Estado 5, Procedimiento sp_OACreate, Lnea 1The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.Mens 50000, Nivel 16, Estado 1, Procedimiento sw_get_sequence_trans, Lnea 57(SWERROR) Unable to create DMO connection, check user is system administrator (ID:001001)

 

Any suggestion

 

Thanks in advance.

[Pablo Rabago]

The problem is now resolved.

It was swpro permission problems in the Master database.

[enco trio]

Hello,Please can yopu explain how di you resolved "The EXECUTE permission was denied on the object" error I trye to give permission like belowuse [master]

GO

GRANT EXECUTE ON [dbo].[XXXXX] TO [userYY] Bu nothing changed.Also try to resolve by create a new database role like it explained on this post but the same error.Thnx