Single_User

• Kangana Beri

  SSCrazy

  Points: 2184

  More actions

  August 12, 2008 at 12:53 pm

  #196962

  I have a security login 'test'. This login has db_datareader, db_datawriter and db_ddladmin roles assigned on a database D. This login has also been granted ALTER DATABASE permission on database D. My question is:

  Can 'test' put the Database D in single_user mode, do some processing and then put the database back in multi_user mode?

  I tried with restricted_user mode, 'test' successfully puts database in restricted_user mode but can not put it back in multi-user mode because 'test' is not part of sysadmin, dbcreator or db_owner role.

• K. Brian Kelley

  SSC Guru

  Points: 114642

  More actions

  August 12, 2008 at 10:18 pm

  #857160

  With ALTER DATABASE it should be able to put the database in SINGLE_USER mode and then back to MULTI_USER mode.

  K. Brian Kelley
  @kbriankelley