May 15, 2006 at 4:03 pm
I m using MSDE as database engine and which will be installed on the client computers along with the front end application. I want to fully secure the msde so that noone can access it not even Windows Administrators. So how to drop all the permissions on my database except sa. hope u got my point
thanks
haroon
May 16, 2006 at 5:05 am
Deny Builtin/Administrators access
-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible. :crazy:
May 16, 2006 at 5:44 am
Problem is that msde will be installed along with the setup program of the Application. So I what script should i run to deny the builtin/Administrators access. And also can someone later grant this access again?
May 17, 2006 at 10:57 pm
If yo uare going down this road then you should
a) Make sure that you provide tools to do things like backup / restore, consistency checks, etc
b) Be aware that any server admin can stop your MSSQLServer service, copy the .mdf & .ldf files and attach them to another server
Cheers.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply