How to set up database permissions

It is common that not only the user who originally performed the installation needs to perform updates, but also other administrator accounts. To do this, it is necessary to set up the appropriate permissions for these additional users. The corresponding steps are described below:

NOTE:
  • All steps apply to all roles of NoSpamProxy; they only differ in the database names.
    • Database Intranet Role: NoSpamProxyIntranetRole
    • Database Gateway Role: NoSpamProxyGatewayRole
    • Database Web Portal: NoSpamProxyWebPortal
  • Users and user groups (local or domain) can be registered
  1. Log on to the system with the user who performed the installation.
  2. Install the SQL Management Studio.
  3. Open SQL Management Studio and log on to the local instance that contains the NoSpamProxy database(s), using Windows authentication.
  4. Expand the Security and Logins folders.
  5. Right-click the Logins folder.
  6. Select New Login from the context menu.
  7. Under General, select the user to be added.
    Keep the item Windows Authentication.
  8. Under Server Roles, check sysadmin.
  9. Under User Mapping, check the box for the corresponding database. Additionally, activate the role db_owner.
  10. Make further optional settings if required.
  11. Save the new login and close SQL Management Studio.

To verify access, log on to the system with the added user, open SQL Management Studio and check if you can view the database tables. If this works, access is set up.