SQL Backup to user

[ISChana]

Dear All,

Can Anybody help is 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]

Please don't cross post...you already posted this in the appropriate forum THREAD962-1106774.

-SQLBill

Posting advice: FAQ481-4875