O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required