DBCC Traceon

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

  • Next message: Andrew J. Kelly: "Re: DBCC Traceon" 
    Date: Sun, 9 Jan 2005 20:09:39 +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
     

  • Next message: Andrew J. Kelly: "Re: DBCC Traceon"

    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.programming)
    • 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)
    • Quantcast