Need permission to run DBCC Traceon | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Need permission to run DBCC Traceon

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

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.

YOu can take EXECUTE AS privileges in SQL 2005, though.

Thanks for the good recommendation!

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |