Roles as table owners

• Jeff W

  SSCertifiable

  Points: 5207

  More actions

  February 12, 2004 at 12:33 pm

  #86062

  Some of you probably already know this.  I have been spending the last 30 minutes playing around in this forum and discovered something about 'roles' and thought I would share.  It is very obvious, but I never thought about it.

  You can create an object with the owner being a role.  For example,

  CREATE TABLE <RoleName>.<TableName>

  If a user in the database is assigned the role it then automatically has all privileges to this table.   I don't think I will ever use this feature for anything, but will think about it

  
  "Keep Your Stick On the Ice" ..Red Green

• SeekQuel

  SSCommitted

  Points: 1818

  More actions

  February 13, 2004 at 2:29 am

  #493960

  Hey,

  Didn't know that, cool!

  It's nice to have all tables linked to "db_owner", because the user "dbo" is linked to one login only. When sysadmin changes...