Easiest way to manage this, create an AD group for the application, put all users of the app into that group, and then grant execute permissions on the stored proces to that AD group. As users come and go, all you have to do is add/remove users from the AD group.