Monday, March 26, 2012

permit RESTORE

Hello,
is it possible to grant a "normal" user the right to RESTORE a special Datab
ase?
Thank You
JoachimHi,
No, "RESTORE DATABASE " can not be granted . User has to be part of any of
the below roles to perform a restore,
1. Systemadmin
2. dbcreator
3. db_owner
Thanks
Hari
MCDAB
"Joachim Hofmann" <speicher@.freenet.de> wrote in message
news:403F4BF5.ADE7C3FE@.freenet.de...
> Hello,
> is it possible to grant a "normal" user the right to RESTORE a special
Database?
> Thank You
> Joachim

No comments:

Post a Comment