I have a multi-database server. The user needs to be able to restore from a backup (of a different database) over a particular database on an ad-hoc basis. The application they use allows them to do this by prompting for backupfile path and database name to resore to .
Giving them the dbcreator role expands this capability too far i.e. they could scrap any of the databases on the server.
I would somehow like to restrict them to a specifc database name to restore to.
Aletrnaive approaches just using TSQL/procs/batch files could be considered.
Thanks in advance.
Rick.