Comprehensive data protection for all workloads
Post Reply
Djura
Lurker
Posts: 2
Liked: never
Joined: Apr 19, 2016 6:51 am
Full Name: Djura Dermisek
Contact:

SQL requirements revisite regarding model role settings

Post by Djura »

Hello,

I would like to place an Enhancement request for the following (reference support case : 01760618):

In the Veeam requirements regarding SQL Backup support and roles it states the following :
SQL system databases (master, msdb and model): db_backupoperator, db_datareader, public;
SQL non-system databases (User databases): db_backupoperator, db_denydatareader, public;

But we would need to the following configuration (because of security and compliancy policies):
SQL system databases (master, msdb): db_backupoperator, db_datareader, public;
SQL system databases (model): db_backupoperator, db_denydatareader, public;
SQL non-system databases (User databases): db_backupoperator, db_denydatareader, public;

Because otherwise (since the model database is the template system database which is used for creating new user database) we will have to change after creating a new user database each time the "db_datareader" option for that database to what it should be "db_denydatareader".
So in short, because of the restrictions regarding the Veeam support requirements of the supported roles, the model database cannot be used (as it is designed by Micorosft) as a template for future creation of new user databases, except
if we (like mentioned earlier) change the role setting each time after creating a new user database.

So please revise this support statement, so that we are able again to use the system database "model" as a template for new database creation.

Thanks in advance for the help!
Gostev
Chief Product Officer
Posts: 31460
Liked: 6648 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL requirements revisite regarding model role settings

Post by Gostev » 1 person likes this post

Hi, Djura. Thanks for your feedback, we will investigate if this is possible.
Djura
Lurker
Posts: 2
Liked: never
Joined: Apr 19, 2016 6:51 am
Full Name: Djura Dermisek
Contact:

Re: SQL requirements revisite regarding model role settings

Post by Djura »

Hello Anton Gostev,

Do you have any update on the status of the investigation regarding my enhancement request?

Thanks in advance, Djura
Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 253 guests