SQL Server Performance

Need permission to run DBCC Traceon

Discussion in 'SQL Server 2005 General DBA Questions' started by georgej, Aug 9, 2007.

  1. georgej New Member

    One of my SQL users needs to run DBCC traceon command. That command requires sysadmin permission to run. But I do NOT want to grant this user as sysadmin. Are there any other way to make this user run such command?
    Thanks for help,
    George
    georgej, Aug 9, 2007
    #2

  2. ndinakar Member

    If you cannot grant the user sa rights, perhaps the user can give you the script and you can run it for him and give him back the results.
    ndinakar, Aug 9, 2007
    #3

  3. satya Moderator

    YOu can take EXECUTE AS privileges in SQL 2005, though.
    satya, Aug 10, 2007
    #4

  4. georgej New Member

    Thanks for the good recommendation!
    georgej, Aug 10, 2007
    #5

Share This Page