db_denydatawriter

Members of the db_denydatawriter fixed database role cannot add, modify, or delete any data in the user tables within a database.

See Also

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