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

Implementing Least Privilege

The principle of least privilege says simply that users and systems should have no greater access than is required to perform their intended duties. This means that users can do what they need to do and nothing more. Other systems can access the secured system to perform their intended operations and can do nothing more. In SQL Server 2008, least privilege is implemented through permissions; however, you must understand several objects and concepts in order to ensure that least privilege is properly implemented. These topics include:

  • Permissions and authorization
  • Ownership chains
  • Credentials

Permissions and Authorization

Permissions are used to authorize the action of users. If a user has the permissions to perform ...

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