Post reply

sql server role for junior dba

  • November 19, 2008 at 7:53 am

    #196552

    whats the best role(s) to assign a junior dba if you want them to see jobs, error logs, activity monitor, and run profiler but not be able to manage jobs or kill processes?

  • November 19, 2008 at 9:38 am

    #900611

    There is no such build in role. The problem with your request is that you cannot create user-defined server roles. So you will end up with granting all kind of permissions to your junior dba.

    For monitoring jobs you have the SQLAgentOperatorRole, for using Profiler you need to grant ALTER TRACE permission. In order to read the errorlog by default you need to be sysadmin, but you could also grant permission on xp_readerrorlog. And so you probably need to grant a couple of more permissions.

    [font="Verdana"]Markus Bohse[/font]

  • November 19, 2008 at 9:42 am

    #900612

    thank you,

    thats what i needed to read!

  • November 19, 2008 at 3:26 pm

    #900762

    VIEW SERVER STATE too.

    ~BOT

    Craig Outcalt


    Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
    My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply