PHISSUG
Home of Filipino Sql Server Enthusiasts
Welcome to PHISSUG
Sign in
|
Join
|
Help
in
SQL Server : Tips, Tricks and Techniques (forum)
Technical Discussions (group)
(Entire Site)
Search
Home
Blogs
Forums
Photos
Downloads
PHISSUG
»
Technical Discussions
»
SQL Server : Tips, Tricks and ...
»
Re: SQL Account that can only execute backup
SQL Account that can only execute backup
Last post 09-13-2007, 3:20 AM by
mpMS
. 2 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
09-13-2007, 1:59 AM
2040
mpMS
Joined on 09-07-2006
Posts 28
SQL Account that can only execute backup
Reply
Quote
I have created a script that will backup a database using the isql CLI. The account that I use have db_owner permission. Can I create an account that is limited to backup access only?
Report abuse
09-13-2007, 3:02 AM
2041
in reply to
2040
lito
Joined on 08-18-2006
Posts 9
Re: SQL Account that can only execute backup
Reply
Quote
Yes. You can make that account a member of the
db_backupoperator
role only.
Report abuse
09-13-2007, 3:20 AM
2044
in reply to
2041
mpMS
Joined on 09-07-2006
Posts 28
Re: SQL Account that can only execute backup
Reply
Quote
thanks lito!
Report abuse
PHISSUG © 2007