Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tincup1992
Starting Member
1 Post |
 Posted - 2008-12-09 : 13:11:00
|
| We have a vendor that logs into our network via vpn and then remote desktops to a server that has SQL 2005 Managment Console. So, This user has 3 databases on our DB server that has an array attached (E: drive) They may need to backup and/or restore these 3 db's. I have it where this users see's only their database. What I want to know is what is the best way to give them the ability to backup/restore to the E: drive only. With Backup privledges, they gain access to backup to C: and E:, but i only want them to be able to backup to the E: drive. I tried to deny any write privs for their user on the c drive through windows security, but sql still lets me backup to c:. Is their a better way via SSIS to do this or what. My main concern is that they only backup/restore their db's to a certain drive (our huge array). |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-09 : 13:31:10
|
| For backup/Restore ,you need to give backup database and Create database or Restore permission for user. You can shared folder alowing user read/write permission so he can only use that folder to do his stuff.You can make subfolders like Backup ,Restore. |
 |
|
|
|
|
|
Help running a job!