Monday, March 12, 2012

How can I keep my DB secure on SQL Server

hi
this is my 1st time on this forum, I need to keep my DB secure on SQL server, that no body can enter into my DB and couldnt see my tables and other elements of DB.
Regards
AHKALTER DATABASE MyDataBasename SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE|||That's no good, Thrasymachus. Administrators can still get to the data. The only way to make sure that absolutely no one can get to the data, is to kill all the current user connections to the database, drop the database, and run the hard disks the database used to sit on through an MRI machine. Salting the earth is an optional step, but is considered a best practice ;-).

No comments:

Post a Comment