3 out of 3 rated this helpful - Rate this topic

Identity and Access Control (Database Engine)

SQL Server 2008

SQL Server 2008 R2

SQL Server includes various methods and tools to configure security for users, services and other accounts to access the system. This page provides links to help you locate the information that you must have to work with Principals (users and login accounts), Roles (groups of Principals), securable objects (Securables) and permissions.

Related Sections

Securing SQL Server: Provides a general overview of the process for how to help secure the SQL Server platform, and working with users and securable objects.

In This Section

Principals (Database Engine): Describestheentities that can request SQL Server resources.
Server-Level Roles: Describes the roles in SQL Server with server-level scope.
Database-Level Roles: Describes the roles in SQL Server with database-level scope.
Credentials (Database Engine): Explains the records that contain the authentication information (credentials) required to connect to a resource outside SQL Server.
Securables: Describes the SQL Server objects that can be secured.
Permissions (Database Engine): Provides information about the permissions that can be assigned to principals on securables.

External Resources

Microsoft TechNet: SQL Server TechCenter: SQL Server 2005 Security and Protection: Provides up to date information about SQL Server Security.

Concepts

Security and Protection (Database Engine)

Threat and Vulnerability Mitigation (Database Engine)

Secure Development (Database Engine)

Secure Deployment (Database Engine)

Secure Operation (Database Engine)

Understanding Impersonation

Other Resources

Context Switching (Database Engine)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD