Closed

SQL Server 2008 - Setting up new role \ user

This project is now closed with a project budget of $30 - $250 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Project Description

SQL Server 2008

Currently, the web sites (Production-BETA and Development) is calling stored procedures through the Administrator's account. (I know that is terrible and that is what this is about.) Obviously the web sites uses a connection string (it is encrypted in the [url removed, login to view]) to run the stored procedures but I am afraid that one day, someone will see the UNencrypted connection string who is not supposed to see it and have Admin access to the database.

I want to create a user in SQL Server 2008 with ONLY execute permissions on the stored procedures for each database (Production-BETA and Development). The SPs call functions, perform updates, inserts, etc. and other SPs.

See full details below.


Detailed Requirements:
SQL Server 2008 - Setting up new role \ user


We are still in final BETA testing and the application has not been released yet but as we are getting very close to release, we need refinement to our database.



Currently, the web sites (Production-BETA and Development) is calling stored procedures through the Administrator's account. (I know that is terrible and that is what this is about.) Obviously the web sites uses a connection string (it is encrypted in the [url removed, login to view]) to run the stored procedures but I am afraid that one day, someone will see the UNencrypted connection string who is not supposed to see it and have Admin access to the database.

I want to create a user in SQL Server 2008 with ONLY execute permissions on the stored procedures for each database (Production-BETA and Development). The SPs call functions, perform updates, inserts, etc. and other SPs.

Something important to consider … occasionally, the PRODUCTION database gets copied to the DEVELOPMENT and QA database.

Once we accept the bid, the delivery time is a short 2 days because this should be an exceptionally quick job. Although not mandatory, we will be giving priority to people with certifications for SQL Server - Administrator. If you have that certification, please include the details because if we choose you, we will confirm it because we have other database work to be completed (index\query performance monitoring ).



You will need to remote into developer’s desktop computer to gain access to the server. You will not be provided RDC access directly into the server since we do not know you. We will invite you an online meeting with GoToMeeting and the desktop you are connecting to will be connected to the server with SQL Server 2008.

Please read the project first and write the word "Understood". Also write your steps and suggestions to complete the project with a short description of what you understood.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online