News and Announcements icon

Power Platform CommunityForums Power Automate - Using Connectors Microsoft Flows Stored...

Power Automate - Using Connectors

Unanswered

Microsoft Flows Stored Procedure Permission denied to Azure SQL Database

Like (0) Share

Report

Report

Posted on 21 Jun 2019 14:44:00 by StefanCuypersQ

4

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

All responses Img

All responses (2)

Answers Img

Answers (0)

StefanCuypersQ 4 on 21 Aug 2019 at 06:07:39

Like (0)

Report

Re: Microsoft Flows Stored Procedure Permission denied to Azure SQL Database

Yes, this is a SQL account.
Note that we moved to an on-prem SQL Server and there it works fine.
Pstork1 67,351 Most Valuable Professional on 20 Aug 2019 at 16:37:28

Like (0)

Report

Re: Microsoft Flows Stored Procedure Permission denied to Azure SQL Database

Is SvcFlowAccess the SQL account used to authenticate the connector? For Azure SQL that has to be a SQL account and that's the account that needs to be able to run the stored procedure.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Leaderboard > Power Automate

#1

Tomac 986 Moderator

#2

stampcoin 699 Super User 2025 Season 2

#3

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans