This should be a simple question, but I cannot seem to find an answer in anywhere.
I'm trying to connect to SQL Server database through the on premise gateway to run a store procedure.
The stored procedure contains 10 tables.
I'm trying to use a user with limited permissions but it only allows me to save the step if the user has the owner role.
If it doesn't have the owner role it time out when I'm trying to save the step.
The stored procedure is just a select statement.
I've tried saving it with and without parameters.
I've tried giving them read/write permissions on the database.
I've tried give them select permissions on the tables.
I've simplified the stored procedure to just query one of the tables but that doesn't allow me to save either.
I've tried using an Active Directory user as well with the same results, in order to save the step it must have the owner role.
I contacted Microsoft support and they couldn't help me.
Does any one know if limited permissions can be used to run a store procedure?
