Wednesday, March 21, 2012

How to set user who cant modify any StoredProc and data in Tables but can read data in Tab

Please give me advise ????

Big SmileBig SmileBig Smile

Go into Management Studio, connect to your database and go to Security-->Users from the treeview. Right click and select New User. Create the use based on the relevant login and then go to the Securables option where you can add tables and stored procedures and select which rights the user will have.

No comments:

Post a Comment