This is SQL Server 2014
A developer attempted to start the Debugger tool and he got this error:
EXECUTE permission was denied on object 'sp_enable_sql_debug', database 'master'.
Even after I granted execute permissions, he still gets this error.
In reading about it, apparently to use the Debugger you must be a member of the sysadmin role.
Is there no other way? A developer needs to be able to run the debugger so why is such a high level of permissions required?
Thanks for any info.