Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
I do not give my customers dbo privileges. Can I use myLittleBackup?
In order to perform a backup or a restore with SQL Server, the user must have very "high-level" permissions like db_owner, db_backupoperator, dbo etc...
The problem is that web-hosting companies does not apply these roles to their customer logins. That's why myLittleBackup offers the possibility to define authorizations based on database roles.
Even if the web-hosting company only wants to give the user db_datareader, db_datawriter, db_ddladmin roles for security reason, it will be still be possible to offer backup/restore features using myLittleBackup.
|