RE: Transfering Database Ownership

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Bandettini (JohnBandettini_at_discussions.microsoft.com)
Date: 02/01/05 

Date: Tue, 1 Feb 2005 04:03:02 -0800

Hi

I take it you mean he is the owner of the database?

Run the following

use (your db name)
EXEC sp_changedbowner 'sa'

It's a good idea to have all your databases owned by sa

Hope this helps

John

"BlondMoment" wrote:

> Hello
>
> We have a database set up by a guy whos leaving this
> Friday.
>
> One of our production databases is in his name, so I was
> wondering how to transfer the ownership of the database to
> someone else.
>
> Thanks
> J
>

Relevant Pages

  • Re: Failed to copy table objects - DTS Wizard
    ... thing - need to change ownership of the databases to login ... >when a database is restored or attached. ... >EXEC sp_changedbowner 'TemoOwner' ... >SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Change UDF Owner
    ... system_function_schema -especially in the master database. ... is in the context of a database, and can be the schema owner for the the ... Users can be put in the dbo role, ... ownership, and thus avoid the 'dreaded ownership chain' problems, is to ...
    (microsoft.public.sqlserver.security)
  • Re: Cant get global config data and KB 900499 doesnt help
    ... The account you use to create the database MUST have the following rights on ... DECLARE @AdminVSAccount nvarchar ... DECLARE @ContentVSAccount nvarchar ... EXEC sp_grantlogin @ContentVSAccount; ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: sp_start_job, run by normal users?
    ... I was able to create a database, add a user to a role, and get it to execute ... --Delete left over certificate files. ... --I turn it on, do my EXEC, and turn it back off. ... GRANT EXECUTE ON msdb.dbo.sp_start_job TO msdbAuthenticator; ...
    (microsoft.public.sqlserver.security)
  • Re: Permission in database
    ... You can create database roles and assign object permissions to these ... EXEC sp_addrole 'Administrators' ... GRANT SELECT, INSERT, UPDATE, DELETE ON Sales TO Administrators ...
    (microsoft.public.sqlserver.security)