(or to an
Edit Button to the left of any Database Group Name) and click Insert.
The Enter a New Group page will be shown.
All fields marked with an asterisk (*) are required.Repeat these steps for each table for which you want to assign views.
- Click the name of the data table in the Table List box. Listed in the Insert, Update, Delete and Select boxes are the names of the views that are available for the selected data table, and for the view type (table function) that each box represents (Insert, Update, Delete, Select).
If you want to assign the same view to all of the view types (table functions), then select the view name from the Insert box, and click Assign Insert to All.
Pending views can not be assigned to the Select view type (table function). When you select the pending view name in the Insert box and click Assign Insert to All, you will note that the Select box does not update to show the pending view name.
If you want to assign different views to the different view types (table functions), then select the desired view name from each of the Insert, Update, Delete and Select boxes individually.
Exercise caution when assigning different views. For example, if a group is allowed to insert rows into a data table but restricted from selecting rows from the table to display, a user can create a row, but will not be able to see it once it has been inserted into the data table.
- If you are creating a Database Group for Soft Edit users, please refer to the Soft Edit topic for additional instructions.
Click Reset All Views button to reset the group's views on all tables to the original set up. You will be given an opportunity to confirm your intention to reset all views.
Caution! Using Reset All Views will undo every view assignment (for every table) that you have made for the Group.
- No Lookup Table Access - Members of this group may not view, create, edit, or delete entries in any lookup table within table maintenance.
- Select Access Only - Members of this group may view entries in any lookup table via lookup table maintenance, but may not create, update or delete.
- Select, Insert, Update, Delete - Members of this group may view, create, edit, and delete entries in any lookup table.
The default option is No Lookup Table Access. Click one of the other options to change it.
(Note that Access and Maintenance permissions can also be applied to individual lookup table entries based on the Access and Maintenance settings within each lookup table entry.)
- Dues - the system will link the creation of a Membership row to the creation of a Dues row. The system will automatically prompt for the creation of a Dues row before processing a Membership. Conversely, the system will automatically prompt for the creation of a Membership row after inserting a Dues row.
- Membership - the system will create a Membership row without any automatic linking to either Giving or Dues.
The default option is Dues. Click Membership to change it.
- When a new user is assigned membership to a group that has been assigned a default report queue, the default report queue for the new user will default to the default report queue of the group. You can, if you desire, change the user default report queue before inserting the new user into the database.
- If you edit the group's default report queue - either assign a default queue to the group for the first time, switch default queues from one queue to another, or reset the group's default queue to (none) - then the default report queue for those users who had the same default queue as the group's will automatically change to the group's new default report queue. The default queue remains unchanged for those users who had a different default queue.
- A default queue must be assigned to the group before you can assign a default printer.
- When a new user is assigned membership to a group that has been assigned a default report printer, the default report printer for the new user will default to the default report printer of the group. You can, if you desire, change the user default report printer before inserting the new user into the database.
- If you edit the group's default report printer - either assign a default printer to the group for the first time, switch default printers from one queue to another, or reset the group's default printer to (none) - then the default printer for those users who had the same default printer as the group's will automatically change to the group's new default printer. The default printer remains unchanged for those users who had a different default printer.
- Default Mask applies the System Defined Display Mask, which is an Abila Millennium System Option.
- No Mask displays the entire number.
- Last Four Visible Mask masks all but the last 4 digits.
- Complete Mask masks the entire number.
Default Mask is selected by default. Click one of the other options to change it.
- Default Mask applies the System Defined Display Mask, which is an Abila Millennium System Option.
- No Mask displays the entire number.
- Last Four Visible Mask masks all but the last 4 digits.
- Complete Mask masks the entire number.
Default Mask is selected by default. Click of the other options to change it.
Sage Payment Solutions Processing - If your site has subscribed to Sage Payment Solutions, credit card and bank draft transactions can be entered with one of two process methods - Real-time or Vault Only (or None). Determine which of these process methods users within the group can utilize when they insert credit card and bank draft rows. They may have access to one or two, or None.
When a user is assigned membership to a group that has access to one or both process methods, that user has access to the same process methods as the group. You can remove access to one or more of the process methods from that user. Conversely, you can grant access to certain process methods without having to grant access to those same process methods to the group as a whole. If you change access for the group, the change will cascade to all of the users that belong to the group. See User Maintenance.
Default access to these Sage Payment Solutions Tools - Pledge Processing is a Sage Payment Solutions tool used to create payments that are due to the institution, and automatically process those payments, for pledges and sustainer pledges that are tendered by credit card or bank draft. Virtual Terminal links to the Sage Payment Solutions Virtual Terminal outside of Abila Millennium for the purpose of manually processing credit card and bank draft transactions. Determine which of these tools the users with the group can access. Grant access to one, two, or all three by checking the appropriate check box (s).
When a user is assigned membership to a group that has access to one or both three processing tools, that user has access to the same tools as the group. You can remove access to one or more of the tools from that user. Conversely, you can grant access to one or more of these tools without having to grant access to those same tools to the group as a whole. If you change Tools access for the group, the change will cascade to all of the users that belong to the group. See User Maintenance.
-
Grant Rights to Data Examiner Tables - if checked, the group will have full access to all of the pending tables used by the Online Constituent Directory, the Advanced Data Examiner and the Advanced Data Examiner Import Tool. These are optional Abila Millennium components. If your site does not subscribe to them, this option will be disabled.
Rights to the Data Examiner cannot be granted for an individual user, but are granted to the group as a whole.
Soft Edit users must be granted rights to the Data Examiner Tables as well.
-
Report Admin -check this option to grant Report Administrator privileges to all users within the group. A Report Administrator can open a report owned by any other user, make changes to that report, and assume ownership of that report.
When a user is assigned membership to a group with Report Administrator privileges, by default that user is also a Report Administrator. You can remove the Report Administrator privileges from that user. Conversely, you can assign Report Administrator privileges to an individual user without having to grant Report Administrator privileges to the group as a whole. If you change Report Administrator privileges for the group, the change will cascade to all of the users that belong to the group. See User Maintenance.