I have run into something i can't find any answer to and maybe you can help me.
In SQL 2012 and 2014, if a user have the server role dbcreator and public and create a databas that user got db_owner db role on the created database and could do what ever he needed to with that database.
In SQL 2016 this does not happen and the database you create gets inaccessable because the user is added to the database only as a user and not as a db_owner and sa is set as dbo. Does anyone know of any changes in the roles between 2012/2014 and 2016 regarding this and how do i solve it, what server role does, the lowest possible, a user need to have go become db_owner on the database it creates?
I need a user, that can create a databas and become db_owner on the databas he creates but not be an sysadmin.
Best regards Ronny