Granting Access to a Database
Applies To: SQL Server 2016
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.
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