InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 12:06:12 GMT20http://www.sqlservercentral.com/Forums/Topic1422312-1550-1.aspxPerfect.ThanksSat, 23 Feb 2013 10:00:45 GMT- Winhttp://www.sqlservercentral.com/Forums/Topic1422312-1550-1.aspxTo run profiler or create traces requires either sysadmin or ALTER TRACE permission on the server. If they have neither (and devs shouldn't have either on a prod server), then they cannot create traces.Sat, 23 Feb 2013 03:31:59 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1422312-1550-1.aspxThanks Lynn, got what I needed from there (not sure why my first couple Google searches didn't find that) - appreciate your help![quote]Users who have the SHOWPLAN, the ALTER TRACE, or the VIEW SERVER STATE permission can view queries that are captured in Showplan output. These queries may contain sensitive information such as passwords. Therefore, we recommend that you only grant these permissions to users who are authorized to view sensitive information, such as members of the db_owner fixed database role, or members of the sysadmin fixed server role. Additionally, we recommend that you only save Showplan files or trace files that contain Showplan-related events to a location that uses the NTFS file system, and that you restrict access to users who are authorized to view sensitive information.[/quote]Fri, 22 Feb 2013 14:01:00 GMTMyDoggieJessiehttp://www.sqlservercentral.com/Forums/Topic1422312-1550-1.aspxDoes this help?[b][url]http://msdn.microsoft.com/en-us/library/ms187611.aspx[/url][/b]Wed, 20 Feb 2013 14:51:39 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1422312-1550-1.aspxA few of our SQL Report writers have figured out how to execute SQL profiler to trace queries that they are working on. For my own reasons, I'd like to disable this - possible?Wed, 20 Feb 2013 14:43:09 GMTMyDoggieJessie