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
Solved

SQL rights

Posted on 2007-11-29
2
570 Views
Last Modified: 2007-11-29
I want to create a SQL user account that can login to Studio Manager and manager only the DB I assign to them.  Can someone point me in the right direction.

Thanks
0
Comment
Question by:madayes
2 Comments
 
LVL 6

Accepted Solution

by:
thuannguy earned 65 total points
ID: 20373449
In short: Open the SQL Managament Studio, connect to the SQL server. In the Object explorer pane, expand the Security folder, right click on LOGINS to create a login account. On the opend LOGIN window, after you fill in all required information, navigate to the User mapping tab and map that login to databases which you want that login has access to.
0
 
LVL 3

Assisted Solution

by:dbarker2
dbarker2 earned 60 total points
ID: 20373484
Open Studio Manager and expand the Security folder in the left paine.
-Right click on Logins and select new login
-Type the users name (If the user has an AD login you can click search and locate it).
-Choose either windows authentication (If you used an AD login) or SQL Server Authentication.
-At the bottom of the General window in the Default Database dropdown choose the proper database.
-In the left paine click on User Mappings.
-In the right paine choose the Database you want to assign him rights to and check the box.
-in the bottom paine select the rights you would like to apply (Typically db_owner to manage the DB).

That should do it.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Compare data between two databases 16 109
MS SQL page split per second is high 19 103
ms sql + top 1 for each customer 3 56
Getting max record but maybe not use Group BY 2 32
This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
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…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

808 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