Database Locking

[SnehaAgrawal]

Hi I want to know how can I lock my database...I mean if someone wishes to see he should be able to see only Database Name He should not be able to see tables,Sp's,UDF 'S...I don't want to set permissions bcoz permissions can be changed by ADMIN...

[balame2004]

This is interesting question. Very useful if someone explain the possibilities.

[ck9663]

They're called ADMIN because they can do anything. Being the highest user, you can not stop them from doing anything. If you can, that makes you the ADMIN which makes everything a cycle :)

Good luck


--- CK

[prabirchoudhury]

ok..

Set the database into single user mode so only one connection can access it

sp_dboption 'databaseName', single, true

Set the database to readonly

sp_dboption 'databaseName', read only, true

that might solve problem..