I created a stored procedure in an Azure SQL Database and granted EXECUTE permission, but Microsoft Flow keeps erroring out with
The EXECUTE permission was denied on the object 'HelloTest'
Any ideas why?
We use the account SvcFlowAccess to access the SQL server. If we connect with SSMS using that account it can execute the procedure.
The procedure was created with:
CREATE PROCEDURE HelloTest
AS
SELECT 'A' AS A
GO
GRANT EXECUTE ON HelloTest TO SvcFlowAccess
GO
