Promote user to database administrator

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

On Aug 8, 1:16 pm, AZ Steve <AZSt....TakeThisOut@discussions.microsoft.com> wrote:
> 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.