Promote user to database administrator

A

AZ 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
 
L

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
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.
 
R

ryanholliday

I am not saavy enough to set up a user as the database administrator through
the method outlined on the technet site. Is there an easier way where I can
get the same results?
 
Top