I tried to use deny view. Still it is not working.
How i did is
- Logged in as Admin
- Went to the Database, Security folder-->Users--Selected the User-->Property-->Securable-->Add Securable-->I mentioned the object (Store Procedure) and denied the view.
Plz correct me if i'm wrong.