2 out of 5 rated this helpful - Rate this topic

Granting Access to a Database

SQL Server 2005

New: 14 April 2006

Mary now has access to this instance of SQL Server 2005, 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.
Copy
USE [TestData]; GO CREATE USER [Mary] FOR LOGIN [computer_name\Mary]; GO
Now, Mary has access to both SQL Server 2005 and the TestData database.

Next Task in Lesson

Creating Views and Stored Procedures

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD