Can someone explain, what are the database roles?
Posted Answers
Database roels are created at the Database Security level for use by specific database. SQL Server also has several predefined database security roles:
db_owner
Perform any activity of all the other database roles and any database administrative tasks.
db_accessadmin
Add or remove any Windows NT accounts or SQL Server users from the database.
Db_datareader
View data in any user table in the database.
Db_datawriter
Add, change, or delete data from any user table in the database.
Db_dlladmin
Add, modify, or drop any object in the database.
Db_securityadmin
Manage SQL Server database roles, as well as statements and objects permissions related to the database.
Db_backupoperator
Back up the database.
Db_denydatareader
Make schema changes to the database (but not see any data in the datatabase)
Db_denydatawriter
View the data in the database (but not change any data).
Answer by: Anonymous