SQL Backup to users

[ISChana]

Dear All,

Can Anybody help in solving this problem.

I like to know how a user(Not Administrator)can take the SQL backup without seeing the SQL Server tables
More clearly

I have win 2000 server and SQL 2000 installed on it. Data is stored in SQL We have given Sa password to SQL Server.As I am administrator i do everthing like SQL Backup etc from administrator. Now I like to give this facility to some user

User should only these provileges

1.There should be user A/c and he has the permissoion only to shut down system and to take the SQL Database Backup.But he should not be able to open the SQL Database otherwise he can modify the data.

Please guide..
With regards

Inderjeet

 

[SQLBill]

I don't believe you can do what you are asking. If you give some one the database role of db_backupoperator, they can do backups, run DBCC commands and do restores.

I believe the person would be able to backup the database and restore it somewhere else, make changes, back it up again and restore it back to where it was originally.

You don't give backup permissions to someone you don't/can't trust.

-SQLBill

Posting advice: FAQ481-4875