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

  1. Type and execute the following statements (replacing computer_name with the name of your computer) to grant Mary access to the TestData database.

    USE [TestData];  
    GO  
    
    CREATE USER [Mary] FOR LOGIN [computer_name\Mary];  
    GO  
    

    Now, Mary has access to both SQL Server and the TestData database.

Next Task in Lesson

Creating Views and Stored Procedures