June 25, 2002 at 4:40 am
Hey,
Just a quick question regarding the Read Only property for Databases.
From what I understand, this option allows users to only "Select" data from the Database. Will setting the DB to read only effect any DTS Jobs or Stored Procs that I have that Insert and Update data in the DB?
The only Updates to this DB are from Scheduled Jobs that run both DTS's and SP's. Users only ever use SELECT.
Thanks,
Clive Strong
June 25, 2002 at 4:57 am
Yes it will prevent them. It is better to create put the users in the db_denydatawriter and db_datareader roles. Or create a single role with grant on SELECT and deny on other options then puts users in that role.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 25, 2002 at 5:07 am
Thanks for that Antares.
I did a bit of digging and found that Read Only turns of Auto Update Statistics, so I'll go with your idea on that one!
Cheers!
Clive Strong
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply