• 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.