Loading

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

anjali khan

10y841

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar Singh10y ago
Accepted 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.
0
Kashif Sohail10y ago
you can use user name and password for authentication. only the authanticated user will be able to makes the changes
0