Four tables manage Stonefield Query security:

  • USERS.DBF: contains the names of the users defined in the Maintain Users and Groups dialog in Stonefield Query. This table is located in the Data subdirectory of the Stonefield Query program directory, so regardless of the number of projects being used in Stonefield Query, there is a single set of users for all projects.

  • ROLES.DBF: contains the names of the roles defined in the Maintain Users and Groups dialog in Stonefield Query. This table is located in the Data subdirectory of the Stonefield Query program directory, so regardless of the number of projects being used in Stonefield Query, there is a single set of roles for all projects.

  • USERROLES.DBF: specifies which users are members of which roles. Like the USERS and ROLES tables, this table is located in the Data subdirectory of the Stonefield Query program directory.

  • SECURITY.DBF: contains the security access of roles to reports, folders, and data groups. This table is located in the project data directory (the same directory as REPORTS.DBF), so it's specific to a project.

In addition to these, the roles that can access a particular table or field are stored in the ROLES column in the data dictionary table.

Do not write to these tables directly, as doing so improperly can damage their contents and make reports, folders, or even all of Stonefield Query inaccessible. Instead, use the Maintain Users and Groups dialog. None of these tables need to be distributed to your users; they are automatically created the first time a user runs Stonefield Query, and are populated with default records:

  • Two roles are automatically defined and cannot be renamed or deleted: Administrators and Everyone.

  • One user is automatically defined: ADMIN, which belongs to the Administrators role. This user can be renamed but can only be deleted if there's at least one other member of the Administrators role.