O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Chapter 16. User and Security Management

In addition to backup and recovery, the tasks of user and security management are probably the most important tasks that SQL Server DBA must perform. In the last few years, the job of security management has become much more important. In this chapter, you will be introduced to the basic concepts of SQL Server user and security management: logins, user IDs, schemas, permissions, and roles.

The SQL Server login is the method that allows users to connect in to the SQL Server instance. The login is the connection to the outside world. Within each database are user ids that provide a way of regulating access at the database level. Logins are mapped into user IDs at the database ...

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