Table Access Registry entry
Specify which tables (modules) can be accessed by users / groups.
This Registry entry determines whether a user / group has access to a module and its data. When a table is listed in a Table Access Registry entry for a group, a button is added to the Command Centre, providing members of the group with access to the module and its records subject to the group's Operations permissions.
Note: The Operations and Table Access Registry entries work hand in hand: the Table Access Registry entry determines which modules a user / group is permitted to access; the Operations Registry entry then determines what actions the user / group is permitted to perform in the module.
For example, if a user is to import records into the Parties module, they must have (or belong to a group that has) both a Table Access Registry entry that lists the eparties module AND an Operations Registry entry that specifies the daImport
permission for the Parties module. In other words, possessing the daImport permission for the Parties module is insufficient to import records into the Parties module; it is also necessary to have Table Access to the eparties table.
If a table is not listed in a Table Access Registry entry, the module cannot be accessed from the Command Centre and, as a rule, a user cannot view or modify any data from that table even if they have been assigned Operations permissions to data in the table.
Exception
The exception to this rule is viewing an attachment. If a user / group does not have a Table Access Registry entry for a module but does have the daDisplay
Operations privilege for that module, it is possible to open the module to view an attachment record from a module that the user does have access to. For example, a user:
- has Table Access to the Catalogue module but not the Parties module
-AND-
- has the
daDisplay
Operations privilege for the Parties module.
If a Parties record is attached to a Catalogue record, the user will be able to open and display the Parties module to view the attached Parties record by clicking View Attachment (for example) in the Catalogue record.
Usage
This Registry entry can be assigned to users and groups:
Key | User | Group |
---|---|---|
Key 1 | User
|
Group
|
Key 2 | user | group |
Key 3 | Table Access
|
|
Value | table;table;... |
User
|
user | Table Access
|
table;table;... |
Group
|
group | Table Access
|
table;table;... |
where:
table;table;... |
is a semicolon separated list of table names, e.g. eparties for the Parties module. Table names
|
Example
This entry specifies which tables the Manager group can access:
Key | Setting |
---|---|
Key 1 | Group
|
Key 2 | Manager |
Key 3 | Table Access
|
Value |
|