Using the Object Level Security, it allows you to set Grant and Deny permissions on Tables, Views and Schema's.
I would be great you will be able to set permissions ons Stored Procedures as well. Use case is discussed in the following article:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.