db_owner role

• hawg

  SSCertifiable

  Points: 6044

  More actions

  February 11, 2003 at 3:17 pm

  #80826

  Can someone tell me if the a member of the db_owner role can actually change the name of the database in which they are a member of this role?

  This may sound simple but I am needing an answer fast and I can't seem to find a definitive answer.

  Thanks in advance.

  ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  February 11, 2003 at 5:23 pm

  #448706

  BOL says you have to be in syadmin or dbcreator roles, so db_owner is not enough.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter