Tag Archives: Permissions

TSQL to find users and their access on a given database

TSQL to find users and their access on a given database

Posted in Script, SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment

Access to run SQL Profiler/Trace – Minimum access

If you need to provide access to someone only to run SQL Profiler SQL Trace you need to Grant ALTER TRACE permission. This feature is introduced in SQL Server 2005… – Permissions to run SQL Trace Reference: http://msdn.microsoft.com/en-IN/library/ms187611.aspx -Vijred

Posted in Productivity, Referene, Script, SQL, SQL Query | Tagged , , , , , , | Leave a comment