Grant Execute Role

Granting execute permissions to all stored procedures in a database

CREATE ROLE db_executor

GRANT EXECUTE TO db_executor


from article on SqlDbaTips.com

Missing Index in Sql Server

The following query displays required index on sql database.

use databse
go

select *
from sys.dm_db_missing_index_details
where database_id = db_id()