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.
1 Answer
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
