error when dbower trying to change database property.

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  October 23, 2014 at 6:05 pm

  #291429

  A developer is granted dbowner of some his own databases.

  Some of the databases are set to read_only.

  He tried to change some databases from read only back to read write from management studio, so he goes to the database name, right click and it pops up an error message something like: there is no guest account exists in the database.

  What does that mean? Can db owner change the database from read-only or read-write?

  Thanks,

• vincyf1

  Say Hey Kid

  Points: 696

  More actions

  October 24, 2014 at 2:55 am

  #1754558

  For Altering Database Properties, I reckon you would require a Server level ALTER privileges.

  Being DB_Owner would not be sufficient.