Grant Execute permission to user in SQL Server

we need to create database role in particular database where user wants execute permission.

Use DB_NAME
GO
CREATE ROLE [db_executor]
GO

Grant the execute permission to database role:

Grant execute to [db_executor]

Now add the user to the database role

ALTER ROLE [db_executor] ADD MEMBER [User-Name]
GO

• Tweet
• Share
• Share
• Share
• Share