Rank: Administration Groups: Administration
Joined: 9/11/2006 Posts: 605 Points: 649 Location: Enghien Les Bains, France
|
My needs are to give customers access to their own databases to allow them to backup/restore data. They would not be allowed to see any other databases etc... Very restricted.
When a user is connected, he can only see the databases he has access to, i.e the databases he has an account on and the databases with a guest account.
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.
|