Performing Security Tasks

Securing a database is a critical and challenging task. The following table lists topics in SQL Server 2005 Books Online that can help you understand and set up security in Microsoft SQL Server 2005 Express Edition (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 2005 Books Online topic
Understand security concepts	Principals Server-Level Roles Database-Level Roles Permissions Permissions Hierarchy 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)