The default file contains the following lines:

This allows any UNICOM Intelligence Interviewer - Server Admin user to access the Participants database on YourDBServer. (“Participants” is the default database for storing sample records.) If you want to allow access to the Participants database on any server you can replace the server name with an asterisk.

Settings in the Default section apply to any user who belongs to a role that is not specified in the Role section of the file. If there is no Default section then these users will not be able to access any sample databases on any servers at all.

To store the participants table in the project database, set Database name to %PROJECTDB%. This will be substituted by the name of the project database. For example:

Add a <Database> tag for each one underneath the one for Participants. To give access to other servers, add a new <Server> tag with its own <Database> specification. The following example allows everyone to access all databases on the Red server, but only the Participants database on the Blue server.

If you omit the <Database> tag for a server, all users can access all databases on that server.

Add the cancreatenewdatabase and cancreatenewtable properties. For example:

You can restrict users to accessing only certain tables and/or fields within a database, although this is something you might be more likely to do at the role level rather than the default level. The general syntax for setting permissions on tables and fields is as follows:

You can allow non-administrator users to create databases, and provide the non-administrator users access to those databases, as follows: