db_owner
Members of the db_owner fixed database role can perform all configuration and maintenance activities on the database.
Important
In SQL Server 2005, members of the db_owner fixed database role can drop a database. This is a change of behavior from earlier versions.
See Also
Reference
Concepts
Permissions of Fixed Database Roles
Other Resources
sp_dbfixedrolepermission (Transact-SQL)
sp_helpdbfixedrole (Transact-SQL)
Security Considerations for Databases and Database Applications