DBCC Traceon

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Tudor Sofron (tudor.sofron_at_mydomain.com)
Date: 01/07/05 

Date: Fri, 7 Jan 2005 20:36:35 +0200

Hello all,
I have written a procedure which imports data into SQL Server from MySQL
using driver 3.51.06. Nothing unusual til now but the fact that the stored
procedure is using dbcc traceon (8765). So, I grant execute to an ordinary
user on the procedure, the user can execute it but the procedure throws the
error that the user cannot run dbcc traceon. Does anybody know what specific
rights do I have to grant to the users for running dbcc traceon or if there
is some other option instead of using dbcc traceon.

Thanks,
Tudor
 

Relevant Pages

  • DBCC Traceon
    ... using driver 3.51.06. ... Nothing unusual til now but the fact that the stored ... I grant execute to an ordinary ... error that the user cannot run dbcc traceon. ...
    (microsoft.public.sqlserver.security)
  • Re: DBCC Traceon
    ... I can't find reference to that trace flag. ... Andrew J. Kelly SQL MVP "Tudor Sofron" wrote in message ... Nothing unusual til now but the fact that the stored> procedure is using dbcc traceon. ... So, I grant execute to an ordinary> user on the procedure, the user can execute it but the procedure throws> the ...
    (microsoft.public.sqlserver.security)
  • Re: DBCC Traceon
    ... To run DBCC TRACEON you must be a member of the sysadmin role. ... ordinary user can not run this. ... > "Tudor Sofron" wrote in message ...
    (microsoft.public.sqlserver.security)
  • Re: DBCC Traceon
    ... this is one of the links found with google by searching dbcc traceon. ... The resons I have use that trace flag are the ... I grant execute to an ordinary ...
    (microsoft.public.sqlserver.security)