New user and associated database tutorial, sqlserver Database

New user and associated database tutorial, sqlserver Database

We often need to create a user with permissions on the database. This user can only operate on a specific database (for example, this user can only read, write, and so on ), so how should we set it on sqlserver? The following steps are a bit long. You only need to set them step by step.

Method/step

If you have not activated sqlserver identity authentication, first enter the Management System to activate the windowns identity.

 

Property-right-click Security-activate

 

 

Then you need to restart (In the context menu)

 

Then, choose "security"> "Login Name"> "Add new login name ".

 

Enter the user name and password. It is best to enable the forced password policy for the password.

 

Then, in the database where you want to activate user permissions, find security-right-click-create-user

 

Enter the user name and select the user architecture and role. Here, select db-owner (with full permissions)

 

Finally, use the Account link

 

If you click another database, you will be prompted that you do not have permission