I read many articles related to self provisioning system where application is capable of creting db assets on first deployment. I have slightly different views on this. Below are the reasons.
- Difficult to make changes without redeploying the code as there is tight coupling between code and assets needs to be created or modified.
- Permissions needs to be given to the system/super admin user that is running the application.
- As a repercussion of two if security of your deployed application is compromised than you may loose your DB.
- Most of the financial org. avoids this due to security aspects.
Overall, do read out on new options that are getting traction but do diligence on new features if it makes sense in the context that you are applying them.