May 20, 2013 at 1:25 pm
Is it possible don´t allow a user to open transactions ?
May 20, 2013 at 1:29 pm
Deny them insert, update and delete on all tables in the database. Only way since all data modifications run in transactions
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
May 20, 2013 at 1:34 pm
Let me explain,
Some users are members of db_datareader role, and frequently they open transaction to deploy select on database and I need deny this option.
Like
BEGIN TRAN
select * from table
May 20, 2013 at 1:38 pm
That doesn't actually start a transaction, and you can prove it by running that in one management studio window and running DBCC OPENTRAN in another.
The transaction will only start when the first data modification runs within the transaction scope. If they don't run a data modification, then there's no actual transaction and hence nothing to be concerned about.
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