Promote user to database administrator

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to give a user admiistator rights to the database without
making them an administrator on the PC? I created the database loged in as
the admiistrator and now the user cant backup or perform other administrative
updates/customizations. Dont want to make them a local administrator on the
PC is avoidable.

Steve
 
Is there any way to give a user admiistator rights to the database without
making them an administrator on the PC? I created the database loged in as
the admiistrator and now the user cant backup or perform other administrative
updates/customizations. Dont want to make them a local administrator on the
PC is avoidable.

Steve
Click to expand...

You can assign database owner to a user with sp_changedbowner:
http://technet.microsoft.com/en-us/library/ms178630.aspx

You should also be able to give a user permission to do individual
actions, like backup.
 
Back
Top