How to restrict to anyone that he can't b modified db in sql

Question

Hi frnds

I want to know that how to restrict,noone can change the db in SQL..

Suppose I m doing a work on db and makes it..
Now want to know if anyone doing the work on same db or system ,but they can't be able to change db ? How to do it?

Amit Singh · Answer

Hey Anjali For Database:- Authentication with Username and password For Table:- Open your MS Sql Server-->Tools--->Options--->Designers---->Table and Database Designers--->Prevent Saving Changes that require table recreation.

Kashif Sohail · Answer

you can use user name and password for authentication. only the authanticated user will be able to makes the changes