Serenic Navigator User Access Rules
Overview
Jet has the ability to apply Serenic Navigator's User Access Rules to all queries that are run by a user to which one or more rules apply. This feature can be enabled by importing the Navigator to Jet Bus Objects table into the Navigator database.
Configuring Business Objects (available from Serenic)
For each Business Object, there is a set of field mappings in the Navigator to Jet Bus Objects table. These field mappings determine to which field in which tables the User Access Rules will be applied for a given Business Object. These field mappings will have to be imported into Navigator either by hand or using a Dataport.
The Navigator to Jet Bus Objects table has the following 5 fields:
Field No. | Field Name | Data Type | Description |
---|---|---|---|
1 | Table No. | Integer | The number of the table to which the Business Object corresponds. |
2 | Field No. | Integer | The number of the field to which the Business Object corresponds. |
3 | Business Object | Code | The Business Object ID. This will either be a code, i.e. GLACCOUNT, or the dimension number. |
4 | Object Type | Option | The type of Business Object defined in the "Business Object" field. This can either be code or dimension |
5 | Field Caption | Text | The caption of the field as defined in the "Field No." field. This field is for convenience only and is not used by Jet. |
The following are examples of rows that define some Business Object mappings back to the G/L Account table:
Table No. | Field No. | Business Object | Object Type | Field Caption |
---|---|---|---|---|
15 | 1 | GLACCOUNT | code | No. |
15 | 29 | 1 | dimension | Global Dimension 1 Filter |
The rows above define two field mappings back to table 15 ("G/L Account") in the database. The first row indicates that User Access Rules for the “GLACCOUNT” Business Object will be applied to the “No.” field in the “G/L Account” table. Note that the object type is "code", and the business object (GLACCOUNT) maps directly to the name of an existing Business Object.
The second row in the example has an object type of "dimension". This means that the value in the "Business Object" field should correspond to a dimension number, in this case dimension "1". This row indicates that User Access Rules for dimension 1, or "PROGRAM" in the Navigator sample database, will be applied to the "Global Dimension 1 Filter" field in the "G/L Account" table.