hi,
need some info on SQL 2008. one of my x-colig asked me on this scenario, i said with Tablock but i am not too confident on that, AFAIK, we have to apply trigger to prevent table drop.
case: Org has two databases as DB1 and DB2, for accessing every user has to authenticate themselves...