Ok. Now, I would like to know if I can restrict unauthorised users from doing all kinds of operations like generating scripts, updating or deleting records, deleting tables even after they have entered the database using a password, which might have reached their hands by some mistake. It is possible to prevent deleting of records using an instead of trigger as I read it. But, I am looking for a solution where in a user would have to reauthorise to perform any of these operations. i would like to know about the solution in SQL server 2000. And also, the password protection for each database is only in the SQL server 2005 compact edition. Can anybody please elaborate on this edition?

Thanks