The EXECUTE permission was denied on the object xp_availablemedia One of my colleagues has Public role on SQL Management Studio but db_owner on a couple of DB. While trying to CREATE back-up, the following message pops up



I have now added db_backupoperator on the DB, still the following error
The reason is that the user has enough permissions to perform a backup, but not enough permissions to enumerate the filesystem on the server, which is what SSMS does behind the scenes.

This behaviour is described in this support page, which suggests adding the login to the sysadmin role.

To work around it, add a backup device with sp_addumpdevice and let the user backup to that device.