Please refer the following table for Database Level Permissions.
| Role | DML Operations |
| db_accessadmin | Select, Update, Delete, Insert Not Working |
| db_backupoperator | Select, Update, Delete, Insert Not Working |
| db_datareader | Select Working |
| db_datawriter | Select Not Working Update, Delete, Insert Working |
| db_ddladmin | Select, Update, Delete, Insert Not Working |
| db_denydatareader | Select, Update, Delete, Insert Not Working |
| db_denydatareader with db_datareader | Select, Update, Delete, Insert Not Working |
| db_denydatawriter | Select, Update, Delete, Insert Not Working |
| db_denydatawriter with db_datawriter | Select, Update, Delete, Insert Not Working |
| db_dbowner | Select, Update, Delete, Insert Working |
| db_dbowner with db_denydatareader | Select Not Working Update, Delete, Insert Working |
| db_dbowner with db_denydatawriter | Select Working Update, Delete, Insert Not Working |
| db_securityadmin | Select, Update, Delete, Insert Not Working |
| sysadmin | Select, Update, Delete, Insert Working |
| sysadmin with db_denydatareader | Select, Update, Delete, Insert Working |
| sysadmin with db_denydatawriter | Select, Update, Delete, Insert Working |
No comments:
Post a Comment