SQL Server® 2008 Administration: Real World Skills for MCITP Certification and Beyond

Logins, Users, and Roles

You will ultimately build your authentication and authorization solution for SQL Server through the use of logins, users, and roles. The logins will get the users into the SQL Server system. The user objects will get the users into the databases, and the roles will define what they can do in the databases. When the rubber meets the road and you're ready to start configuring authentication for SQL Server 2008, you will need to be able to perform three basic tasks:

1. Configure the authentication mode.
2. Create and manage principals and roles.
3. Create and manage database users.

Before you can begin granting permission to securables in your databases, you will need to have some principals to which you can grant the permissions. ...