Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Access rights for Junior SQL Server DBA in 2005

Posted on 2011-03-18
1
Medium Priority
?
381 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
1 Comment
 
LVL 2

Accepted Solution

by:
EL_Barbado earned 2000 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

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

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

Background Information Recently I have fixed file server permission issues for one of my client. The client has 1800 users and one Windows Server 2008 R2 domain joined file server with 12 TB of data, 250+ shared folders and the folder structure i…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
The viewer will learn how to count occurrences of each item in an array.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

810 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