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.
...
Modify _ dmSecUserDirectories.cfm
Add the following to the _dmSecUserDirectories.cfm file. FoUsers
("myUD" can be any variable name, but note that this name is reflected in the security tab. )
| Code Block |
|---|
// External Authentication Client User Directory application.dmSec.UserDirectory.myUD = structNew(); <!--- // choose a unique struct name in inplaceplace of 'myUD' ---> temp = application.dmSec.UserDirectory.myUD; temp.type = "Daemon"; <!--- // the type MUST be "Daemon" when using a SQL database ---> temp.datasource = "myDatasource"; <!---// the name of the ColdFusion DSN created previously ---> |
Final Setup
You should now see your new UserDirectory in the Policy and Security tabs. You must add mappings from the normal FarCry policy groups to external groups you've just added. Since we already set up groups, and the mappings between the users and groups, all that's left to do is map the groups to policies.
...