Essential SQL Server Concepts - Microsoft Business Intelligence Tools for Excel Analysts - page 159

Figure 8-5: Users and database roles.
Add a database user by right-clicking the Users folder in the Object Explorer window and selecting
New User. The Database User - New window opens, where you can add a new database user. Every
database user must have a server login. To simplify security admin, give the database user the same
name as the server login.
After naming the user and assigning the proper server login, you have to define the user's database
access level. There are two primary approaching to defining access level:
➤ Database Role: Gives the user general database access, making it easier for you to adminis-
ter security because you do not have to specifically declare access for each object in your
database.
➤ Database Object Access: Allows you fine control over your database security. This is
discussed in detail in the next section.