Grant DatabaseBackup sp execution privilege to a non-sysadmin user

[JParkACR]

I (SA) want to grant the [DatabaseBackup] SP execution privilege to a non sysadmin role member.

Currently one of the SQL Server user have a enough privileges to create a db backup with using the generic backup command in the SQL Server, but not able to use the [DatabaseBackup] SP. It failed due to the 'xp_ss_delete' or 'xp_fileexist' steps in the SP.

I have digging into the SPs, and found '@ExecuteAsUser' parameter in [CommandExecute] SP, but there is no documentation or comment about this parameter and couldn't figure out how to use it.

I believe there must be a "needs" to use the DatabaseBackup SP for non sysadmin user. And hope to make it possible.