Loading

How to add different user with different permission for the Database

vinnu

15y2.5k

hi..

i want to create a different user with different permissions..

i have one database..named School Database..

now what i want is i want the principle with different

login name and password and the staff with different login name

and password..

and the main thing the principle should have the rights to

create delete and edit permission and the staff should have

only the read permission ...

I'm using Sql server 2008

help me....

1 Reply

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

Morcos Adel15y ago
i think you could search for logins in sql server and then right click on your database and select properties then permissions...then grant the permissions needed to the logins you created...
This Article here shows exactly what you need to do :
http://www.c-sharpcorner.com/UploadFile/GemingLeader/sql-server-logins10202009105217AM/sql-server-logins.aspx
0