Skip to content
+1-888-319-3663

COMMUNITY FORUM

the EXECUTE permission was denied

Mike Geak asked 2 years ago
When running an integration to GP we receive this error:
“The EXECUTE permission was denied on the object ‘taGLTransactionLineInsert’, database’ABC’, schema ‘dbo’.”
 
This map was duplicated, and updated for the correct entity. This map works perfectly for the original entity.
Answers
Patrick Roth Staff answered 2 years ago
Mike,
This isn’t a SmartConnect “Map” error – it is a SQL error.
It means that your user on the eConnect Service (not smartconnect) on THIS machine does not have permissions to that stored procedure.
You should run the GP grant.sql on that ABC database in SSMS.  And while you are there, make sure that this same eConnect Service user has been granted the DYNGP permissions on that same ABC database.
Once you do that, this proc (and any others) should execute correctly and the map will run fine against that ABC company.

If you would like to submit an answer or comment, please sign in to the eOne portal.