1.Grants users permissions to execute a stored procedure irrespective of the related tables.
3.Grant users users permission to work with a stored procedure to access a restricted set of data yet no give them permissions to update or select underlying data.
3.Stored procedures can be granted execute permissions rather than setting permissions on data itself.
4.Provide more granular security control through stored procedures rather than complete control on underlying data in tables.