To a bunch of users? I'd say no, it is not a good idea. Do you really have a bunch of users that are capable of understanding execution plans? Furthermore, if you are interrested in hiding business logic from users, you should definitely not grant them showplan, as execution plans reveal quite a lot.
Ole Kristian Velstadbråten Bangås -
Virinco -
Facebook -
TwitterConcatenating Row Values in Transact-SQL[/url]