I needed a custom SQL Server role which has readonly access to all databases, regardless of whether a database is existing or is newly created.
The role is not a problem. The problem is that the role will not be applied to existing databases. If I create a new database, the role is applied and does working as I expected.
I assume there will be some system stored procedure that will be run at the moment, a new database is created.
Is there any possibility to apply the custom server role afterwards to databases which are existed before i created the custom server role?
I am using SQL Server 2012.
Thanks in advance