Default settings
The default file contains the following lines:
<SampleManagementGUI>
<Default>
<Server name="YourDBServer">
<Database name="Participants">
</Database>
</Server>
</Default>
</SampleManagementGUI>
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 allow all users to access other sample databases
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.
<Default>
<Server name="Red">
<Database name="*" >
</Database>
</Server>
<Server name="Blue">
<Database name="Participants" >
</Database>
</Server>
</Default>
If you omit the <Database> tag for a server, all users can access all databases on that server.
To provide users the option of creating new databases and tables
Add the cancreatenewdatabase and cancreatenewtable properties. For example:
<Default>
<Server name="
ServerName" cancreatenewdatabase="True">
<Database name="
DatabaseName" cancreatenewtable="True">
<Table name="
TableName">
<Field name="
FieldName" />
</Table>
</Database>
</Server>
</Default>
To restrict users to accessing only certain tables and/or fields within a database
You can restrict users to accessing only certain tables and/or fields within a database, although this is something you may 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:
<Default>
<Server name="
ServerName">
<Database name="
DatabaseName">
<Table name="
TableName">
<Field name="
FieldName" />
</Table>
</Database>
</Server>
</Default>
You can allow non-administrator users to create databases, and provide the non-administrator users access to those databases, as follows:
<User UserName="NonAdminUser">
<Server name="DBServerNameNonAdminUserCanAccess">
<Database name = "*" cancreatenewtable="True">
</Database>
</Server>
</User>
See also