Blocking problem

[David Bobko]

When an SA attempts to change permission on any object they are shown as blocked as expected. However as new users access the object the SA's process is continuely blocked until the object is free. Can anyone explain this??

Thanks
David

[Fred]

When object permissions are edited, this changes
the object definition. These changes cannot take
place until the object is completely free. It
requires an exclusive table lock

fred

------------
David Bobko at 4/19/00 3:57:50 PM

When an SA attempts to change permission on any object they are shown as blocked as expected. However as new users access the object the SA's process is continuely blocked until the object is free. Can anyone explain this??

Thanks
David

[David Bobko]

Why cant this process take control of the object in between users?


------------
Fred at 4/19/00 4:09:53 PM

When object permissions are edited, this changes
the object definition. These changes cannot take
place until the object is completely free. It
requires an exclusive table lock

fred

------------
David Bobko at 4/19/00 3:57:50 PM

When an SA attempts to change permission on any object they are shown as blocked as expected. However as new users access the object the SA's process is continuely blocked until the object is free. Can anyone explain this??

Thanks
David

[Fred]

an object has to be totally free
in order to obtain an exclusive table lock.
however you can obtain rows and shared locks.

eg: process1 has a shared lock on object a
process2 needs a exclusive table lock
process2 has to wait for object a to be free.
process3 needs to read data from object a
process3 can share object a with process1
process1 finishes and process3 has a shared lock on object a.
process3 is still waiting..

fred.
------------
David Bobko at 4/19/00 4:13:48 PM

Why cant this process take control of the object in between users?


------------
Fred at 4/19/00 4:09:53 PM

When object permissions are edited, this changes
the object definition. These changes cannot take
place until the object is completely free. It
requires an exclusive table lock

fred

------------
David Bobko at 4/19/00 3:57:50 PM

When an SA attempts to change permission on any object they are shown as blocked as expected. However as new users access the object the SA's process is continuely blocked until the object is free. Can anyone explain this??

Thanks
David