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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 permissions

Author  Topic 

page1
Starting Member

1 Post

Posted - 2003-03-29 : 15:58:57
hello,
On sql7 or sql2000 server can you permit some users to do
buckups but no restorage?

thanks

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-03-29 : 17:04:24
Sure, add them to the db_backupoperator fixed database role for the ability to backup specific databases to which they have access.


HTH
Jasper Smith

0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27
Go to Top of Page
   

- Advertisement -