- Statement Permissions
- The CREATE TABLE, VIEW, FUNCTION, PROCEDURE, DEFAULT, and RULE Permissions
- The BACKUP DATABASE and BACKUP LOG Statement Permissions
- Assigning Statement Permissions
- Administering Statement Permissions with SQL Server Enterprise Manager
- About this Article
The BACKUP DATABASE and BACKUP LOG Statement Permissions
The BACKUP DATABASE and BACKUP LOG permissions can also be assigned to individual users, Windows users/groups, and roles. Although backing up the database and transaction logs is usually an automated process carried out by scheduled jobs created by the system administrator, some environments require that individual users be given the ability to perform these backups.
Again, using the db_backupoperator fixed database role is much better than granting the BACKUP DATABASE and BACKUP LOG statement permissions. You usually need the other rights granted by the role membership anyway, and figuring out who has what rights is easier when you take advantage of SQL Server roles.