Execute UDF/extended stored procedure only through view?

From: Neil W (neilw_at_REMOVEnetlib.com)
Date: 11/27/04 

Date: Sat, 27 Nov 2004 11:17:29 -0500

Lets say I have a view, MyView, that calls MyUDF and/or MyExtendedProcedure.

Is there a way I can allow a user to access MyView, but stop them from
directly executing MyUDF or MyExtendedProcedure?

E.g., I'd like them to be able to do this:

    select * from MyView

but stop them from doing this:

    Exec MyExtendedStoredProcedure

Is this possible? Thanks for any tips.