Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

External Authentication - MSSQL Server

This can be useful if a customer relation management system, or similar, holds user information that is to be shared with the FarCry application.

Excerpt

This document is intended to help outline the requirements for adding a new UserDirectory via an external database. The methods described below were written with MSSQL in mind, but should work with databases that support views. It is assumed that you have good working knowledge of databases, the external database to link in particular.

This can be useful if a customer relation management system, or similar, holds user information that is to be shared with the FarCry application.

To create a new UserDirectory , your required to have three database tables/views of the names dmUser , dmGroup , and dmUserToGroup . Below is layout of each of these tables/views. Note that if you're database does not have a matching field to any of the ones below, either substitute it with a similar field, or create a static field in the view. Also note that is not recommended to change this data via the FarCry security interface.

...