O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

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

Principals, Securables, and Permissions

Once you have made it through an endpoint, most of the security that you will deal with revolves around principals, securables, and permissions. You grant permissions on securables to principals.

Principals

Principals are the means by which you authenticate and are identified by within an instance or database. Principals are broken down into two major categories: logins/users and groups that exist at both an instance and database level.

Instance Level Principals

At an instance level, principals are implemented as logins or fixed server roles. In order to gain access to any object within a SQL Server instance, a login must be created inside the instance. Logins within SQL Server 2005 can be of five different ...

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