Skip to content
+1-888-319-3663

COMMUNITY FORUM

SELECT Permission was Denied

Mark asked 6 years ago
I am trying to run a Map and keep getting:
The SELECT permission was denied on the object ‘SY01500’, database ‘Dynamics’, schema ‘dbo’.
The SELECT permission was denied on the object ‘MC-40200’, database ‘Dynamics’, schema ‘dbo’.
Everything in Setup seems to be working
My connectors are setup and working I can pull from GP and update CRM. This Map is updating GP.
Anyone have any idea what I am running into?
Lisa Overlin replied 5 years ago

I have the same issue when we use views to create a smartlist. Then get this same error when logged in as sa.

Answers
Lorren Zemke Staff answered 6 years ago
Mark,
Make sure the user assigned to the eConnect Windows Service has access to the DYNAMICS database and is a member of the DYNGRP roll.
 
Lorren

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