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.
| Author |
Topic |
|
Robwhittaker
Yak Posting Veteran
85 Posts |
 Posted - 2003-03-06 : 06:45:22
|
| On our development server we let our developers back up their databases. However I've just discovered that they are unable to restore a database they have backed up. I've looked in a few manals and BOL but can't find out which server roles let you restore a database. Is there a difinitive list of exactly what each role allows a person to do?ThanksRob |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-06 : 07:05:56
|
| Hope this will help.Bulk insert administrators - Members can issue the BULK INSERT statement.Database creators - Members can CREATE, ALTER, and DROP databases; RESTORE databases and database logs; extend databases; and rename databases.Disk administrators - Members can run the sp_add ump device and sp_dropdevice storedprocedures.Process administrators - Members can use the KILL statement to break user connections to SQL Server.Security administrators - Members have a number of security assignment privileges. Securityadministrators can grant, revoke, or deny the CREATE DATABASE permission. Security administrators can add and drop SQL logins; grant, revoke, or deny Windows logins; and add linked server and remote server logins.Server administrators - Members can issue SHUTDOWN and RECONFIGURE statements; run the sp_configure, sp_tableoption, and sp_fulltext_service stored procedures; and free procedure cache buffers.Setup administrators - Setup administrators can add, drop, and configure linked servers. They also mark a stored procedure as a startup procedure.System administrators - Members of this role can perform any server action. Once a login is a member of this role, it needs no other role membership or permissions to have full access to SQL Server, its databases, and all objects within those databases._____________________________________________________________________Success is not a destination that you ever reach. Success is the quality of your journey.Edited by - samsekar on 03/06/2003 07:09:01 |
 |
|
|
Robwhittaker
Yak Posting Veteran
85 Posts |
Posted - 2003-03-07 : 03:49:46
|
| Thanks for the information, but the little bit off information I wanted was, which of these roles can restore a database. Or is it only saRob |
|
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-07 : 04:30:32
|
| Database Creators & System Administrators can RESTORE the databases.___________________________________________________________________________Success is not a destination that you ever reach. Success is the quality of your journey. |
|
|
|
Robwhittaker
Yak Posting Veteran
85 Posts |
Posted - 2003-03-07 : 04:46:27
|
| Sorry,I didn't read your message properly, it's been one of those weeks.ThanksRob |
|
|
|
|
|
|
|
|
server roles