i would advice to do 2 tests trying to reslove this problem

1)give this user an other name instead of the current

2)connect to sql server direct by the Sql Server Managment...

if you grant execute of this Stored Procedure for this user Explicitly he gets back the permissions to read all the columns selected by this SP

what you need to do...

There is a simple way to do it

In the properties window of the Table you want to hide, set the permissions for this specific user to DENY control,delete,insert,select and update.

The...