Security Tasks (SQL Server Express)

Securing a database is a critical and challenging task. The following table lists topics in SQL Server 2008 Books Online that can help you understand and set up security in Microsoft SQL Server 2008 Express (SQL Server Express).

Important

The topics listed below might refer to user interface elements or features that are not supported by SQL Server Express. For more information about feature support, see Overview of SQL Server Express.

Task	SQL Server Books Online topic
Understand security concepts	Principals (Database Engine) Server-Level Roles Database-Level Roles Permissions (Database Engine) Permissions Hierarchy (Database Engine) Encryption Hierarchy Password Policy Strong Passwords Application Roles
Manage users	CREATE USER (Transact-SQL) ALTER USER (Transact-SQL) DROP USER (Transact-SQL)
Manage logins	CREATE LOGIN (Transact-SQL) ALTER LOGIN (Transact-SQL) DROP LOGIN (Transact-SQL)
Managing roles	CREATE ROLE (Transact-SQL) ALTER ROLE (Transact-SQL) DROP ROLE (Transact-SQL)
Assign or deny permissions	CREATE CREDENTIAL (Transact-SQL) GRANT (Transact-SQL) GRANT Database Permissions (Transact-SQL) DENY (Transact-SQL) DENY Database Permissions (Transact-SQL) REVOKE (Transact-SQL) REVOKE Database Permissions (Transact-SQL)