Re: what permission do a "regular user" need to do backup/restore
- From: "Uri Dimant" <urid@xxxxxxxxxxx>
- Date: Thu, 30 Oct 2008 08:57:44 +0200
If the user is member of db_owner db role he/she will have permission
otherwise BACKUP DATABASE and BACKUP LOG permissions default to members of
the sysadmin fixed server role and db_backupoperator fixed database roles.
BOL says
If the database being restored does not exist, the user must have CREATE
DATABASE permissions to be able to execute RESTORE. If the database exists,
RESTORE permissions default to members of the sysadmin and dbcreator fixed
server roles and the owner (dbo) of the database (for the FROM
DATABASE_SNAPSHOT option, the database always exists).
RESTORE permissions are given to roles in which membership information is
always readily available to the server. Because fixed database role
membership can be checked only when the database is accessible and
undamaged, which is not always the case when RESTORE is executed, members of
the db_owner fixed database role do not have RESTORE permissions.
"sqlapprentice" <sqlapprentice@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5E518DF4-C0FD-490D-B3CD-EF30D304293C@xxxxxxxxxxxxxxxx
Hi,
I need to give backup/restore function to a user "dbo" for his own
database.
This is on SQL 2005.
What permission do I need to setup for this user so I don't give too much.
Thank you for the great support.
.
- References:
- what permission do a "regular user" need to do backup/restore
- From: sqlapprentice
- what permission do a "regular user" need to do backup/restore
- Prev by Date: grant read access to new fields
- Next by Date: Re: grant read access to new fields
- Previous by thread: what permission do a "regular user" need to do backup/restore
- Next by thread: grant read access to new fields
- Index(es):
Relevant Pages
|
