SQL database Assignment permissions

Right-click (new Login), security, login name

Enter the appropriate information (here to remove the mandatory password policy, Force password expiration, otherwise the user must change the password at the next logon)

User mappings, select the database for which we want to set permissions, set permissions for new users by selecting database role Memberships (server role selection public and sysadmin)

General permissions for the entire library when all the permissions are required to check the db_owner.

This will allow us to access our database server with our newly created username, and this username will only have all the permissions of the database we have checked.

SQL database Assignment permissions