Add other users

The other users are added in the same way as the main user but with roles starting with EDB:

  • EDBAdmin – The user can create new databases, delete databases, and edit database settings in SQL Server project management.

  • EDBPowerUser – The user can create and delete SQL Server projects.

  • EDBUser – The user can edit projects.

  • EDBReader – The user only has read-only rights to projects.

Each role in the list automatically includes the user rights of all the roles below them.

Do the following:

  1. Open Microsoft SQL Server Management Studio.

  2. Open the Security node.

  3. Right-click Logins, and select New Login. The Login - New dialog opens.

  4. For Login name, enter the username in the format [domain name]\[Windows username]. In this example, DOMAIN\newuser is used.

  5. Click OK. The program creates the new user into the user folder.

  6. Below Security > Logins, right-click the username you added and select Properties. The Login Properties - [Username] dialog opens.

  7. Select User Mapping.

  8. In the Map column, select the databases you want to give the user the rights to.

  9. Select the desired database roles beginning with EDB, such as EDBPowerUser.

  10. Click OK.

SQL Server is now ready for use, and you can start working on CADMATIC Electrical SQL Server projects.