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 |
|
u2p_inst
Yak Posting Veteran
78 Posts |
 Posted - 2003-08-25 : 08:08:59
|
| Dear All,I have SQL server 2K in my local machine and now if i login to this server as Administrator local machine i can do anything to my database(create,delete,update,...etc),my question is: Is possible to set permission to Administrator (Local machine) and Administrator Domain Controller only for backup database?if possible how i can do that! thx a lot beforeoh |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-25 : 12:20:30
|
| I don't understand your question. Do you want different permissions for the administrators on the backup server? You could remove the BUILT_IN\Administrators group from the system administrators fixed server role, but I'm not sure what you are asking. Could you explain further?Tara |
 |
|
|
u2p_inst
Yak Posting Veteran
78 Posts |
Posted - 2003-08-25 : 22:40:16
|
| my intention is different permission for the Administrator local and Administrator on Domain Controller to login to my server(local machine) not backup server, So The Administrator on local machine and Administrator on Domain Controller only have permission to backup database not to(create,update,insert table).Do you understand now?oh |
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2003-08-26 : 00:41:26
|
| Greetings,You need to remove the the Builtin\Administrator login from the System Administrator( Fixed server role) and add it to Database Creator (Fixed Server Role). By doing so, local admin can only create /alter / backup databases. HTHSamrat |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-26 : 12:33:55
|
| The Database Creator role does not allow backing up of databases. It allows RESTOREs though. For backups, you can add the accounts/roles to the db_backupoperator fixed database role. You will need to remove the BUILTIN\Administrators group from the system administrator fixed server role as Samrat mentioned.Tara |
|
|
|
|
|
|
|
|
Set permission to Administrator