Promote user to database administrator

[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

 

[Luther]

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

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.