Solved

Access rights for Junior SQL Server DBA in 2005

Posted on 2011-03-18
1
370 Views
Last Modified: 2012-05-11
We are hiring a Junior DBA who will be resposible for the following:
1) Manually check DB backups on Production Server
2) Manually check SQL Server error logs and Windows Error logs for any error we need to be concerned about.
3) Manually check under SQL Agent Activity Monitor if a certain job has successfully run or not. However, he CANNOT enable of disable the job.

DO NOT WANT THE Jr DBA to do:
1) Shut down/Restart the server
2) Delete any files on the server
3) Stop any Services.
4) Add/Drop any databases
5) Pretty much no access to change any configuration on the Operationg system level.

ENVIRONMENT:
1) Windows 2008 R2 Standard Edition
2) Microsoft SQL Server 2005 Standard Edition

Any assistance would be appreciated. thanks
0
Comment
Question by:timerack
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
EL_Barbado earned 500 total points
ID: 35165657
Create a login that this jr. DBA will have on the SQL Server. This can be either Windows Domain login or a SQL Server Login.

In management studio, expland the security -> Logins folder.
Right click -> Properties on the jr. DBA login.
Under "Server Roles"  He should only have "Public" checked.
Under "User Mapping" Check the box next to "msdb" type the login in the User column and schema column.
At the bottom of the dialog under "Database Role Membership for:"
Select: db_backupoperator, Public, and SQLAgentReaderRole

This should get you what you want.

0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
An enjoyable and seamless user experience can go a long way on an eCommerce site. While a cohesive layout and engaging copy play roles in creating a positive user experience, some sites neglect aspects that seem marginal but in actuality prove very …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question