I have an application where I deploy .mdf file.
its an standalone application in windows form using .net 3.5
I dont want any other user see my DB structure without whoever created.
please give me suggestion.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sudhakar ChaudharyPosted Oct 30, 2012, 3:25 AM
Step:
Firstly Login To the Server then >>>Security>>New Login (here You create a login for the Server)
Leave the Server Role as it is.
Here You Successfully Assign the Login for Your Server.(Only Server Not to database)
Step : In This Setup Make a Login For your Database As Same as Firstly Your Created.
1) Give the Name of The User
2) In login Name give the Login Name as Your Created For Your Server
3) In The Database Role MemberShip Select as You Want(I am Selected The DB_owner)
One Suggestion:
Please Make Sure that Your connection String is Secure Form The Decomplilation.Like that
thanks..