Stonefield Query provides role-based security at the data dictionary level. You can define which roles can access certain tables and fields in the properties pane for table and field objects. Before you do so, however, you must create the roles.

To create a role, click the Create button () when the Roles panel is selected; alternatively, you can click the drop-down arrow beside the Create button and choose Create Role from the menu, or choose Create Role from the Objects or shortcut menus.

After creating a role, enter the name. Since these names are only used internally in Stonefield Query and not for queries against the database, you don't have to worry about delimiters for names containing spaces or other characters. You are not allowed to leave the name blank or enter a duplicate name.

You can select the tables that belong to a role by either turning on the checkmarks in front of the appropriate tables when the role is selected or selecting a particular table and indicating which roles it belongs to. For fields, you have to do it by selecting the field and then indicating which roles it belongs to. Turning on or off the checkmark for a database turns on or off the checkmark for all tables in that database.