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.
...
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. The fields that matter most will be marked in red. Also note that is not recommended to change this data via the Farcry security interface.
dmUser
These fields are required in the dmUser table/view
...
If there is no field that matches in the database, just create an expression similar to what was done below for UserStatus. A UserStatus of 4 is active in Farcry, and since we're not using Farcry to modify the user active status (this is handled in the external database), it is set to always be 4.
dmGroup
These fields are required in the dmGroup table/view
...
Below is the dmGroup view. Note that SalesPersonID is substituted for GroupNotes . Notes, in the overall scheme, can be null.
dmUserToGroup
These fields are required in the dmUserToGroup table/view
...
Below is the dmUserToGroup that was created.
Create a New DSN
The next step in this process is to create a DSN to the external database within the ColdFusion administrator. This is demonstrated below.
Modify _ serverSpecificVars.cfm
Add the DNS, DBTYPE to the file. Be sure that the name in parenthesis matches the DSN name.
Modify _ dmSecUserDirectories.cfm
Add the following to the file. FoUsers can be any variable name, but note that this name is reflected in the security tab. The type MUST be Daemon when using a SQL database.
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.
...