United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Database Engine

Security Considerations for Databases and Database Applications

Database-Level Roles

db_backupoperator

db_datareader

db_datawriter

db_ddladmin

db_denydatareader

db_denydatawriter

db_owner

db_securityadmin

Minimize

2 out of 12 rated this helpful - Rate this topic

db_datareader

SQL Server 2005

Updated: 12 December 2006

Members of the db_datareader fixed database role can run a SELECT statement against any table or view in the database.

Reference

Database-Level Roles

Concepts

Permissions of Fixed Database Roles

Other Resources

sp_dbfixedrolepermission (Transact-SQL)
sp_helpdbfixedrole (Transact-SQL)
Security Considerations for Databases and Database Applications

Help and Information

Getting SQL Server 2005 Assistance

Release	History
12 December 2006	Changed content: Clarified description of this fixed database role.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.