Table owner

• YS Goh

  Grasshopper

  Points: 10

  More actions

  December 1, 2005 at 2:40 am

  #166370

  Understand that some SQL best practices mentioned that it is better to assign the table owner to a user id instead of leave it as dbo.

  But can i assign the table owner as one of the user-defined database role id? any impact?

   

   

   

• Jo Pattyn

  SSC-Dedicated

  Points: 32350

  More actions

  December 1, 2005 at 4:15 am

  #606988

  can I see a link to these best practises?

  All best practises I've seen mention that all objects should be owned by dbo.

  (permission chaining, limiting wildgrowth,...)

  Databases are normally owned by sa (since that account can't be removed)