CODEWITHSUNDEEP
stored-proceduresrolesstored-functionssp-executesqlazure-managed-database
Iniyavan
Iniyavan

Reputation: 115

SQL Server - EXECUTE permission

In our Azure Managed Instance DB, a new user has been created and given db_datareader, db_datawritter and db_ddladmin. As per MS Documentation, db_ddladmin has CREATE PROCEDURE and ALTER ANY SCHEMA. But when logged in, I am unable to EXECUTE SPs and Functions. Then, separately gave EXECUTE permission.

Now the question is that under which fixed DB role EXECUTE comes? I am unable to find in MS document.

Upvotes: 1

Views: 2412

Answers (1)

Iamsd
Iamsd

Reputation: 21

DB_Owner has execute permission or create your own execute role like below against a database:

-- Create a db_executor role
CREATE ROLE db_executor

-- Grant execute rights to the new role
GRANT EXECUTE TO db_executor

Upvotes: 2

Related Questions