Solved

SQL rights

Posted on 2007-11-29
2
569 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

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…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

770 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