User permissions for someone in SQL 2005

Posted on 2007-07-25
Medium Priority
Last Modified: 2012-06-21
I have a quick and easy question for you. We need a user created who can manage and create just one database. We don't want this person to really be able to do anything in our other DB's.

So I set this up by adding this person as a regular user and remote user on the server itself.
Then on SQL Server they are set up as having a server role of dbcreator and public (seemed like I couldnt get rid of that one).

So now when that user logs in they can see the other Db's but cannot modify anything. They can see everything in their designated DB.

IS this a good way to handle it or is there a better way?
Question by:edi77
1 Comment

Accepted Solution

DantheDBA earned 1500 total points
ID: 19582627
If that is acceptable within your security guidelines then it shouldn't be a problem.

If you would like to tighten it down further though, (and the database they work on is already created), then removed the dbcreator server role and just add their user to the dbowner role for that database.

This will not work if they need to create additional databases though.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

840 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