May 10, 2010 at 8:10 am
Does anyone know if it's possible to change the default SET options for a specific user account?
We're setting up a support login with datareader permissions and would like it to use SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED by default. Is there a way of doing this?
May 10, 2010 at 8:57 am
I do not think that is possible, But I do have a question. Why would you want give that ISOLATION Level? Since you are in SQL 2008 forum, I assume you are using that version. If you are thinking of Blocking because of the queries, You could always use Row Level Version and then you wont have that problem. Read Uncommitted could give you wrong results.
-Roy
May 10, 2010 at 9:40 am
Roy Ernest (5/10/2010)
Why would you want give that ISOLATION Level?
For the simple reason that I hadn't done my homework! The number 1 priority here is performance but I wasn't aware of row versioning.
Having had a quick read of your article[/url] I must admit that row versioning would be the way to go here.
Though I can only assume that this isn't possible either?
May 10, 2010 at 9:47 am
When you set up row level version on your Database level, you do not need to give Isolation level for your user individually. But keep in mind that there will be higher usage of TempDB. That means that the user that you created with db_datareader permission will not be locking tables for any reads. The user will read the last committed data.
There is another thread that is talking about the same issue. Check this thread out.
-Roy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply