how to chaver object owner ship

• sreeni .r.julakanti

  SSC-Addicted

  Points: 499

  More actions

  January 29, 2008 at 2:43 pm

  #120302

  i am trying to change database object owner below

  es,EXEC sp_changeobjectowner 'authors', 'Corporate\GeorgeW';

  GO

  but i am getting this error

  Cannot change owner of object 'AUTHORS' or one of its child objects because the new owner 'dbo' already has an object with the same name.

  Note: i see the object is owned by dbo. authors and user.authors.

  what needs to be done.

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  January 29, 2008 at 11:25 pm

  #773122

  check the credential for user 'Corporate\GeorgeW' he must be member of database role db_owner for the perticular database. Grant permission and try.

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  January 29, 2008 at 11:48 pm

  #773133

  As you do have 2 objects dbo. authors and user.authors with same name like authors you can't change irrespective of database owner you can't change the ownership.

  There is a trick:

  1. rename object user.authors with user.authors_dummy

  2. Now you will be able to change the objectowner. change the objectowner to specific user

  3. rename object user.authors_dummy to user.authors.

  DONE!!!

  You need minimum permission to do this is db_owner.

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."

• rajankjohn

  SSCertifiable

  Points: 5061

  More actions

  January 30, 2008 at 12:11 am

  #773138

  try EXEC sp_changeobjectowner 'existing_owner .authors', 'Corporate\GeorgeW';

  GO