Re: Unable to see SQL Server Agent Node - what permissions do I need?

Chris Wood wrote:
Jan,

You need access to one of the SQLAgentxxxRole(s) in msdb.

There are 3 SQLAgentxxxRole(s) that have different levels of permission. See BOL for more details.

Chris

"Jan Leste" <user@xxxxxxxxxxx> wrote in message news:el6kIjhHHHA.3268@xxxxxxxxxxxxxxxxxxxxxxx
I am a newbie to SQL 2005 and trying to understand the permissions. When I run SQL Management Studio with an account that is not a local admin on the remote SQL Server, I can't see the SQL Agent node at all. What permissions do I need to set in SQL so that I can see that node.

Thanks


Thanks, that's just what I was looking for.
.

Relevant Pages

  • Re: Complete Neophyte Question(s)
    ... You should not have to go Google to find out what WITH GRANT means. ... Server comes with online documentation on you hard disk. ... WITH GRANT is one of the more esotheric features in SQL Server in my ... Or does that depend on the permission? ...
    (microsoft.public.sqlserver.security)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.sqlserver.msde)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Permission denied error 2nd Post
    ... New user of SQL ... Greg that the web user should not normally have that level of permission. ... >> fixed server roles. ... The CREATE DATABASE permission must be explicitly ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Object permissions
    ... only the owner can set the RWOP property on a query. ... Once I removed that line from the sql, ... you grant modify permission on the qryAttendanceActual query. ...
    (microsoft.public.access.security)