I have a 3rd part application that allows a user to create a database to be used with their front end. Every year this user needs to create a few new databases. Id like to lock the user down to :
Create the database through the application provided to create the database.
Allow the user to only manage the database though this application. (Not use anything like Sql managment studio.)
And not give this user any kind of server level permissions. Can it be done?
I do have the option of migrating to sql 2012 if that would help with this.