DBO SChema Creating Tables

• John Burchel

  Hall of Fame

  Points: 3611

  More actions

  August 18, 2006 at 8:49 am

  #75041

   

  Hi All,

  I created a SQL login, Its just belongs to the public role, it also belongs to a role called DEV.

  DEV role can create tables, but how can I make users belonging to HEX create tables in the DBO schema. If I create a table now, it doesnt belong to the dbo schema.

  I dont want to grant them dbo role.

  Is this possible, I hope to hear from you soon.

  Thanks

  ---

  Kindest Regards,

  John Burchel (Trainee Developer)
  

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  August 18, 2006 at 11:01 am

  #655715

  When users create objects, they must qualify the object name with 'dbo' i.e.

  create table dbo.mytable

  Greg

   

  Greg