DBO User is not in Database

• HookSQLDBA7

  SSChampion

  Points: 10709

  More actions

  November 16, 2004 at 7:55 am

  #87053

  I inherited a Database which does not have 'dbo' as a user. Would someone have deleted it? Can this 'dbo' user be added back to the Database and if so do I need to add it to the db_owner fixed database role?

  Kevin

   

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  November 16, 2004 at 10:06 am

  #530308

  Can you post the output of

  select user_name(memberuid) as username ,user_name(groupuid) as group_name from sysmembers

• Taj

  Mr or Mrs. 500

  Points: 596

  More actions

  November 16, 2004 at 10:58 am

  #530320

  dbo in the database is not a user. Its a Alias. Whoever is the database owner his login will deafult to dbo until and unless you change the Alias by running some script.

  If dbo does not exist by itself trying creating a object like ....and see what happen.

  Also try sp_helplogin. It will give you all the logins and there Aliases.

  Create table dbo.table name

  .........

  
  Tajammal Butt

• Andrew McKeon

  SSC Veteran

  Points: 281

  More actions

  November 17, 2004 at 4:13 am

  #530454

  If you want to assign the owner to, say, sa then run

  EXEC sp_changedbowner 'sa'

  You will find that dbo appears as a user and is identfied as 'sa'

  Hope this helps,

  Andrew