O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

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

HOUR 21. SQL Server Authentication

Security is a very important aspect of a server database. It ensures that the data that you enter into the database is protected. In this hour you’ll learn:

The basics of security

The types of authentication available

How to create logins

How to create roles

The Basics of Security

Security is necessary to prohibit access by unauthorized users and to ensure that authorized users have only the rights that you want them to have. SQL Server security is very robust and offers you several alternatives for your security model.

Let’s begin by contrasting SQL Server security to that of a desktop database such as Microsoft Access. Access security is very limited and does not provide you with a lot of protection. ...

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