If your @subject value is set via a process(ie from a table, view, function, or sp)..make sure the user has privs on this process.

HTH