Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 384
  • Last Modified:

Access rights for Junior SQL Server DBA in 2005

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
timerack
Asked:
timerack
1 Solution
 
EL_BarbadoCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now