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

See Also


Database-Level Roles


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

Change History

Release History

12 December 2006

Changed content:
  • Clarified description of this fixed database role.