Home > Administrator Download RBT v1.3.1

Groups

Adding a Group

From the Groups pane, click the green plus sign on the groups pane to display the add group pane. Complete the group name entry and assign designer interface access by selecting the appropriate checkboxes - descriptions are shown below:

  • Non-owner Column Access - Documents saved as group-level documents are accessible to all users in the group. If non-owner column access is granted a user that does not own the document can select and add available columns not currently on the document. To prevent this, uncheck this entry.
  • Custom Column Access - The RBT designer provides the ability to create custom select columns that take free form text entry requiring SQL and DBMS knowledge. To prevent access to this functionality uncheck this entry.
  • SQL Display Access - RBT provides a display of the SQL statement that would be created from the designer selection. This SQL display the table and column name selected and requires basic SQL knowledge to interpret. To prevent access to this functionality uncheck this entry.
  • No Where Clause Required - By default, the RBT designer does not require filter selections that would result in a SQL where clause. To force at least 1 filter entry when users are creating queries - to prevent expensive, full table scan, queries - uncheck this entry.

It is important to note that group access restrictions are cumulative. If a user is assigned to any group with one of the above restrictions that restriction will apply to the user regardless of membership in other groups that do not have the restriction.

adding a new group

Configuring Group Users

From the Add Group pane, click the Users link to display the Add/Remove Users pane.

selecting group users

Check the users you wish to add to this group, uncheck users to remove from group.

Configuring Group Table and Column Access

From the Add group pane, click the Tables link to display the Add/Remove Tables pane to configure group access to selected tables and columns.

granting group access to database tables

Check the tables you wish to make available to this group. Uncheck a table to deny access. Clicking the column icon will display the Hidden Columns pane. Check the columns you would like to hide from this group. Hidden columns will not display in the Designer application. Tables and hidden columns selected at a group level will apply to all users in that group and cannot be modified at the user access level.

Editing a Group

From the Groups pane, click on the pencil next to the group name to edit the group. See the Adding a Group section above for full description.

editing a Group

Deleting a Group

To delete a group click the red - you will be prompted to confirm the delete.. The administrators and designers groups cannot be deleted.

deleting a group