How do I share or change database ownership

From: Rick Mullings (rickmullings@hotmail.com)
Date: 08/27/02 

From: "Rick Mullings" <rickmullings@hotmail.com>
Date: Tue, 27 Aug 2002 09:16:56 -0700

NuMedics Inc.
Rick Mullings

I am having some problems with granting ALTER table rights to a new user. I
was told that only the owner of the database can ALTER tables. So my
question is, how do I change or share the ownership from SYSDBA to the newly
created user. Is this possible?

Relevant Pages

  • Re: SqlBulkCopy permissions
    ... ALTER TABLE permission is ... I didn't think SQL Server allowed granting ALTER ... I thought you had to be owner of the table or database to be able to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Error code = 4060
    ... Via a measured escalation in rights, it appears that it was sufficient to ... give the app pool identity 'owner' rights on the PROF database for the ... needed at the db level in a shared services environment as described in the ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Rights to change an SP
    ... What do you mean by "ownership chain issues"? ... >>I'd like to give a user the rights to change the code a several specific ... >>However I don't want to make him an owner of the database. ...
    (microsoft.public.sqlserver.security)