User read access to an archived database

• lulu_lutz

  SSCrazy

  Points: 2155

  More actions

  March 3, 2011 at 8:59 am

  #235414

  How would I give users access to an archived database? I don't think it's good practice to allow them sysadmin, and I can't add the user to the security, but the database is archived (read-only).

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  March 3, 2011 at 11:45 am

  #1294195

  I'd wait for a maint window then make the DB read/write, add the user and then reset to read-only.

  USE [master]

  GO

  ALTER DATABASE [SomeDB] SET READ_WRITE WITH NO_WAIT

  GO

  CREATE USER [SomeUser] FOR LOGIN [SomeDomain\SomeUser]

  GO

  USE [SomeDB]

  GO

  GRANT SELECT ON SCHEMA::[dbo] TO [SomeUser]

  GO

  ALTER DATABASE [SomeDB] SET READ_ONLY WITH NO_WAIT

  GO

  _____________________________________________________________________
  - Nate

  @nate_hughes

• lulu_lutz

  SSCrazy

  Points: 2155

  More actions

  March 3, 2011 at 11:47 am

  #1294201

  Thank you for your response!