Lesson 2-2 - Granting Access to a Database
Mary now has access to this instance of SQL Server , but does not have permission to access the databases. She does not even have access to her default database TestData until you authorize her as a database user.
To grant Mary access, switch to the TestData database, and then use the CREATE USER statement to map her login to a user named Mary.
To create a user in a database
Type and execute the following statements (replacing
computer_namewith the name of your computer) to grant
Maryaccess to the
USE [TestData]; GO CREATE USER [Mary] FOR LOGIN [computer_name\Mary]; GO
Now, Mary has access to both SQL Server and the