Groups
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.

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

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.

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.
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.

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

|