Experience summary 30--sqlserver New user

When it comes to database security, you should create a new user to connect without using SA for database connectivity.

1, Login.

2. Security-Login name-Right click New User.
3, General. Enter the login name, select authentication, enter a password, cancel the Enforce password policy, and select the default database.
4, User mapping. Select the database.
5, state. Grant and enable.
6. Right-click Instance-Properties-security to enable two-step verification.

8. View database permissions. You can increase permissions only if you have basic connectivity features.

Note: The user should have as few permissions as possible after the project is done, and finally only has access to the connection.

Once other permissions are involved, you can configure it with the highest permissions.

Experience summary 30--sqlserver New user