SQL rights

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
madayesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
thuannguyConnect With a Mentor Commented:
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
 
Donald BarkerConnect With a Mentor Manager, Endpoint SecurityCommented:
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
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.

All Courses

From novice to tech pro — start learning today.