Table Field Data Authorizations (ttams3146m000)
Use this session to maintain table field data authorizations. This means that you can specify restrictions for normal users that are linked to the role to do database actions on records of a table for a given condition. Table field data authorizations are specified in a table for a range of data by defining a condition. The authorization, which is defined in this session can be an exception or an addition to the authorizations that are defined in the Table Field Authorizations (ttams3143m000) session.
You can use table field data authorizations to make a table field and to display a field or a hidden field for the normal users that are linked to the role.
You can define authorizations depending on the data of a table field. For example, a user can be allowed to only insert sales orders with the order number is between 100.000 and 200.000.
You can specify an authorization level for each condition, for example, the data authorization. This can be another authorization level as the table authorization level, which is defined in the database table field authorization sessions. If you have not specified table field data authorizations, the table authorization is the same as the database table authorization of the table.
An overlap can occur between two conditions for the same table with different authorization levels. The most restrictive authorization level is taken in this case.
For the meaning of the condition within the expression, see the list of expressions below:
| Cond. | Seq. | Field | Operator | Value 1 | And/Or/End |
|---|---|---|---|---|---|
| 1 | 1 | X | equal | 1 | And |
| 1 | 2 | Y | equal | 3 | Or |
| 2 | 1 | Z | equal | 4 | End |
| Cond. | Seq. | Field | Operator | Value 1 | And/Or/End |
|---|---|---|---|---|---|
| 1 | 1 | X | equal | 1 | And |
| 2 | 1 | Y | equal | 3 | Or |
| 2 | 2 | Z | equal | 4 | End |
When specifying these two expressions, they will turn out to be different.
Expression 1: (X=1 and Y=3) or (Z=4) Expression 2: (X=1) and (Y=3 or Z=4)
You can define the table field data authorizations for all companies or for a specific company. The authorizations for the specific company have the highest authorities in this case.
The table field data authorizations are an exception to the database table-field authorizations.
You can use the appropriate menu to:
- Delete the table field data authorizations for a range of tables fields.
- Convert the changes of the database table authorizations to the run-time data dictionary. The database-authorization data of the role is stored in the $BSE/lib/db/<first character of role>/<role>.
- Role
-
Specifies the code of the role.
- Role
-
The description of the role.
- All Companies
-
If this check box is selected, the authorizations are defined for all companies.
If authorizations are defined for a specific company, as well as for all companies, they can overlap. The authorizations for a specific company have the highest priority.
- Company
-
Specifies the code of the specific company for which the database table-field authorizations are defined.
- Company
-
No Help topic is associated with this item.
- Field Name
-
Specifies the table field for which the database table field authorizations are defined.
If Customer Defined Fields (CDF) are defined for the table, they can also be used in the authorization process. In this field, specify the name of the CDF field as displayed in the Customer Defined Fields (ttadv4591m000) session. The session adds the “
cdf_” prefix to the field. When you zoom on this field, you can choose between zooming to normal table fields and zooming to CDF fields.Note: To work properly in authorizations, the CDF field must be present in the current package combination of the user that defines the authorizations. - Field Name
-
The description or name of the code.
- Authorization
-
Specifies the possible table field authorizations.
- Cond.
-
If the expression consists of multiple conditions, the condition sequence-number is specified.
The use of the condition sequence-number in relation to the serial number can be explained by the following examples:
Cond. Sern. Field Operndr Value 1 And/Or/End 1 1 X equal 1 And 1 2 Y equal 3 Or 2 1 Z equal 4 End Cond. Sern. Field Operndr Value 1 And/Or/End 1 1 X equal 1 And 2 1 Y equal 3 Or 2 2 Z equal 4 End Expression 1: (X=1 and Y=3) or (Z=4) Expression 2: (X=1) and (Y=3 or Z=4)
- Sern
-
Specifies the number of the subexpression in the condition. An expression can contain more than one subexpression.
- Field
-
Specifies the code of the table field to which the condition applies.
- Operator
-
Specifies the operator that you can use in the expression.
- Value 1
-
The value of the field in the condition.
- Value 2
-
Only if the operator is between or not between, the second value applicable.
- And/Or/End
-
The operator who links two conditions, which can be and or which can be or. The expression is closed by using end of expression. If you have entered a condition that is closed by end of expression, all conditions after that will be ignored.