How to Make High Security in MS SQL Server

Security is very important think that we need to know and careful on your data. As you know data in each organization is kept secret. They don’t allow someone know except theirs staff. Another thing they must prevents the data lost. If your data are stolen it effect to your organization because they will know your secret data. How to prevent above problem? Here are some tips to make high security to prevent your data from hacker or other person that want to steal your data. To make high security on MS SQL Server there are 2 things. One is prevent someone steal and prevent it lost.

How to prevent data from someone? The best answer is make user policy. That mean we need to create user for only person that manage data. And you must set user security to the right user.

What we know when we create new user? Here are the options that we assign to new user:

For clearly we create new user and we will explain you about each function to make high security:

General

Login name: for enter user name.

            Windows authentication:  This option means we assign database permission to user have                   in window account to access database.

            SQL Server authentication: To assign permission to Window user and create user for SQL               Server to access to database. It means after we login computer we have other user to login to SQL Server.

Server Roles

                This property to grand server-wide security privileges to user.  

User Mapping

            User mapping is the feature for map which database user can use. Ex: We grand permission to user A can access database ProductDB. So user A cannot access other database in system. After we map database we can set action permission to user that allow user can read, write and update or full access.  

Status

For enable or disable user to login database.

Note: when we create new user we must to make strong password.