How to deny write permission to a user group for few hours in SQL SEVER

• saaharjit_24

  Grasshopper

  Points: 18

  More actions

  September 17, 2018 at 8:19 am

  #368325

  We have a bunch of queries that we run every month end. These queries store data from our production database to the reporting database. There's a user group that has read/write access to the database and we want to deny just the write access only for 2 hours. Is that possible to have this process automated every month end?

• SQLPirate

  SSCrazy

  Points: 2880

  More actions

  September 17, 2018 at 8:31 am

  #2005956

  You can set up a SQL Agent job with a schedule that will run on the last day of every month and does that for you.