Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohit_sharan
Starting Member
22 Posts |
 Posted - 2003-12-04 : 07:10:25
|
| Hi ,Can we have a session level locking for a particula level.... Lets take an example u1 is having two sessions. One session can perform any DML's activity to a table t1 and same user with different session can be restricted to perform ony select statement. Is there a way to solve my query...Thanks with Regards.-Mohit. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-12-04 : 07:51:49
|
| Using the same login within SQL Server, no. Something like that would require the application to manage it. The closest you can get to doing this is to design stored procedures to do all of the work. Grant the user permission to the stored procedures, and deny the user access to the tables. Do not allow users the ability to write ad-hoc SQL or create ad-hoc tables, etc. |
 |
|
|
|
|
|
Table locking in Session...