troubleshooting Question
How to create different level of user profiles in SQL Server Management Studio
Shiv Saha
asked on
asked on
I am very new to SQL Server 2012 admin. Can someone please guide me? I want to create several user logins( with different privileges) so that users can access the database(s) from different machines. If I look at SQL management Studio, I see “Logins” under “Security” and again I see “Users” under “Security” under individual Databases. Do I need to create username in both places? I’d like to know how do I create username with different level of access.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.