Adding New Microsoft SQL Database Users

Users have only public, db_datareader and db_datawriter roles that allow to access database, read and write tables. Within a database, one login can be used only by one user. Mind, that the login used to enter the database is already used by you and it can't be used to create a new user on this database. Therefore, when you create a new user to the database, the system will offer you to choose from the logins that aren't used by this database.

To add a new user to individual Microsoft SQL database:

  1. Select Microsoft SQL databases in the Databases menu.
  2. On the page that appears, click the name of existing database or click the Edit icon in the Controls section. The following form will show:

  3. At the bottom of the page click Add icon against the Database users field. The following form will appear:

  4. Enter user name.
  5. Choose login this user will belong to and click Add.
  6. Agree to additional charges if any.