Re: Script for Permissions to Use Tools

From: "Russell Fields" <russellfields@xxxxxxxxxx>
Date: Fri, 14 Nov 2008 14:35:29 -0500

Ray, What version of SQL Server are you running? The answer varies. - RLF

"RayAtTheBeach" <RayAtTheBeach@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A03BB930-FB67-4A0B-8A11-53DAB8D2AA39@xxxxxxxxxxxxxxxx

I'm hoping someone already has a script out there to grant only necessary
permissions (not SA role membership) for a user to run the following:

Database Tuning Advisor
SQL Profiler
Activity Monitor (for all sessions)

Any help would be appreciated.

Thanks in advance.

References:
- Script for Permissions to Use Tools
  - From: RayAtTheBeach

Prev by Date: Re: Do I need to grant permissions to table as well as view?
Next by Date: Re: Do I need to grant permissions to table as well as view?
Previous by thread: Script for Permissions to Use Tools
Next by thread: Do I need to grant permissions to table as well as view?
Index(es):
- Date
- Thread

Relevant Pages

Re: **Deny**
... usually done when permissions are inherited via role membership. ... GRANT and DENY have no affect on db_owner role members. ...
(microsoft.public.sqlserver.security)
Script for Permissions to Use Tools
... I'm hoping someone already has a script out there to grant only necessary ... permissions (not SA role membership) for a user to run the following: ... Database Tuning Advisor ...
(microsoft.public.sqlserver.security)
Re: SELECT permission denied...
... Thanks for the reply Scott, no i didn't touch the role membership so maybe ... my statement about giving it all permissions was wrong... ... Steve ...
(microsoft.public.dotnet.framework.aspnet)