Post reply

How can SQL Profiler to monitor Stored Procedure execute Permission?

  • September 16, 2010 at 12:05 pm

    #238400

    Most of time, I need to assist developers to troubleshoot Stored Procedure. One Situation I met is permission denied. I logged in to Management Studio with the user which that SP used and run Stored Procedure. There is no any problem. But developer didn’t believe this way. They prefer to use SQL Profiler to trace permission issue.

    So I open a new trace to monitor this SP, the question is SQL Profiler didn’t show me the difference between having execute permission and no execute permission.

    Does anybody know if we can monitor Permission issue using SQL Profiler? If yes, which event should I use?

    Thank you very much!

  • September 16, 2010 at 12:09 pm

    #1222470

    I don't think Profiler can be used to veiw permissions.

    Instead you can check who all has the execute permissions on the stored proc in the SSMS.

    Thank You,

    Best Regards,

    SQLBuddy

  • September 16, 2010 at 12:18 pm

    #1222477

    sqlbuddy123 (9/16/2010)

    Instead you can check who all has the execute permissions on the stored proc in the SSMS.

    Thank you for quick response.

    In fact, I did the same thing. As long as the developers (in my company) see "permission denied" associated with Stored Procedure, they will say it is SQL Server issue. Even though I checked SP permission and test it, they still want to more evidence, like SQL Profiler.

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

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