How can i secure my MDF file?
-
If a user is a local admin of the box they can gain full access to the database via integrated security. They can create their own database and attach .MDF
How can i secure the .MDF so that no one can gain access to it?
PB -
- With sqlserver, you can revoke builtin\administators from the logins of your server. Be carefull with that, because it will need your services to use a windows-account ! Make sure _you_ are granted the needed rights (maybe even sa) before you remove builtin\administrators.
If you are the sole user of this sqlserver instance, there may be no problem.
- If someone can shutdown the sqlserver service, (s)he can copy the mdf/ldf files and attatch them to another sqlserver without you knowing it !
This is one of the reasones why administrative rights should only be given when needed.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply