Granting ShowPlan in PROD

  • Would granting ShowPlan in PROD to bunch of users in PROD a good idea? Also, can someone have an article that points out why it's not a good idea? Thanks

  • 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 - Twitter

    Concatenating Row Values in Transact-SQL[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply