Export (0) Print
Expand All
1 out of 2 rated this helpful - Rate this topic

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_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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.