SECURITY QUESTIONS: GRANT PERMISSIONS TO ALL STORED PROCEDURES / Allow user to EXEC and EXCUTE command in sqlserver

--Listing 1. Grant exec to all stored procedures in a database
GRANT EXEC TO [User]
GO

--Listing 2. Permissions based on executing stored procedures in a schema

GRANT EXEC ON SCHEMA::SomeSchema TO [User]

For Eg:

USE EmpDb
GRANT EXEC TO Selva;
GRANT EXECUTE TO Selva;