Tag Archives: Permissions

How to provide access to SSRS Reports – Giving access only on specific activity

SSRS Access will be managed through Roles only. Giving access to a user or group is assigning the user/group to a specific role. This can be done through the SSRS Reports. Each roles will be assigned with specific tasks so … Continue reading

Posted in Productivity, Uncategorized | Tagged , , , , | Leave a comment

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