ACESS LOCK

[toddmartin]

All,

LOCKING MODIFIER ACCESS will restrict the users to DROP the table ?

Todd

 

[dnoeth]

Why don't you try it yourself?

As you need an exclusive lock to drop a table, an access lock prevents drop or alter table.

Dieter

 

[toddmartin]

Let me explain in detail, one macro is access a table thru a view ,and view has been defined with LOCKING ACCESS , at the same time the other user who has permission to DROP the Table is trying to DROP this table , but he couldn't do it because there is a ACCESS LOCK granted on this table for the first user .

So access lock will not allow to drop the table . If this the case i need to take excluse lock on table and then DROP

Can you help me out to understand when there is a ACCESS LOCK , why other user cannot drop the table

 

[dnoeth]

Just think about the consequences when you drop a table while another process is reading data from it ;-)

Dieter