July 30, 2009 at 9:22 am
Hi all,
I would want to know if it is possible an user who has grants for select and update a table, he can't open transactions again it.
Thanks a lot.
July 30, 2009 at 9:27 am
What do you mean by 'can't open transaction'?
Is your user getting an error? If so, what error?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 30, 2009 at 1:29 pm
Hi Gila,
I am going to try to explain me better. I have an application web and I have to give the opportunity at an external user that doing queries (select and update) again a table. I created an user for them for using the table but I want to avoid that they might do any query in transaction and loocking my table, so I need to do somethinq in order to they can't do transactions. I would want to know whether is possible doing that an user can't open transaction (begin transaction) through denied some grant.
I hope that now the issue would more clear.
Thanks,
Angel.
July 30, 2009 at 1:52 pm
All data changes are done as part of a transaction, whether the transaction be explicitly started or not. Even a single statement update is done as a transaction (which includes the update and any triggers that update fires). The only way someone can not be allowed to begin a transaction is if they are not allowed to make any data changes at all.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply