|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
 |
Administration | |
|
Backup/Restore | |
|
Connectivity | |
|
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How can I grant to user the RESTORE DATABASE permission? Answer: The RESTORE DATABASE permission cannot be granted or revoked. If you need to grant to the user the restore permission, add the user to the dbcreator fixed server role. You can use the sp_addsrvrolemember system stored procedure to add the user to a fixed server role. This is the example of using the sp_addsrvrolemember stored procedure to add John to the dbcreator fixed server role: EXEC sp_addsrvrolemember 'John', 'dbcreator' See SQL Server Books Online for more details about the sp_addsrvrolemember system stored procedure. |