Scenario 3: Permissions for a database backup manager

A user with the manage server permissions privilege issues the following to allow user Mike, who is a user in master database, but not in other user databases, to run dump database, dump transaction, checkpoint, and quiesce database on all user databases:

use master
grant dump any database to mike
grant use any database to mike
grant checkpoint any database to mike
grant quiesce any database to mike