Performing Security Tasks

  • Article

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)