Table Field Authorizations (ttams4112m000)
Use this session to define Table Field Authorizations. Table Field Authorizations can be conditional (formerly known as Data Authorization). The session supports defining authorizations on all levels: Package, Module, Table Field and Company.
Field Information
- Context
-
This field determines whether the role is an AMS role, a SEC role, or an EM role. In the latter case, the Central Enterprise Modeler Company, Project Model, Version and Optimization Phase fields determine the Enterprise Modeler context.
Note: You cannot manually specify SEC roles and EM roles. - Central Comp
-
For an EM role, this field indicates in which central Enterprise Modeler company the EM role is defined. For a SEC role, this field indicates in which authorization and security company the SEC role is defined.
- Project Model
-
This field indicates to which Enterprise Modeler project model the Enterprise Modeler role applies. The field is only relevant if the context is EM.
- Version
-
The Enterprise Modeler version in which the Enterprise Modeler role is defined. The field is only relevant if the context is EM.
- Optimization Phase
-
The Enterprise Modeler optimization phase in which the Enterprise Modeler role is defined. The field is only relevant if the context is EM.
- Role
-
The role code.
- Changed
-
Indicates whether the role was changed. For example, when the role Description has changed, or when one or more authorizations have changed. The field indicates that the role must be converted to runtime.
- Authorized Field
-
This field contains the Table Field code to which the authorization applies.
- All Companies
-
This check box indicates whether the session authorization applies to all companies.
- Company
-
The company to which the authorization applies.
- Conditional
-
This check box indicates the table field authorization is conditional. When a table field authorization is conditional, a condition text must be specified
- Sequence
-
A technical field used to make authorizations unique.
- Authorization
-
The Authorization level.
- Changed
-
This check box indicates whether the table field authorization is changed. The field indicates that the table field authorization must be converted to runtime.
- Condition Text
-
If the Conditional check box is selected, this display field shows the condition text.
This field is maintained by the Text Editor.
Conditional expression
The conditional expression is a logical expression that returns True or False.
Enclose the expression by parenthesis: (expression)
The expression consists of operands and operators, where operands can also be an expression:
Expression = (Operand_A operator Operand_B)
Operand_A, Operand_B = constant (integer/float/string), table field or expression.
Operator = comparison operator or range operator
Range operators a and b refers to constant(integer/float/string) of the table field
This table shows the comparison operators you can use in the expression:
= Equal to (EQ) <> Not equal to (NE) != Not equal to (NE) > Greater than (GT) < Less than (LT) >= Greater than or equal to (GE) <= Less than or equal to (LE) This table shows the range definition:
[a..b] Range between a and b, including both a and b [a..b> Range between a and b, including a and excluding b <a..b] Range between a and b, excluding a and including b <a..b> Range between a and b, excluding both a and b in Exists in range not in Does not exist in range Note: string literals must be single quoted.
This table shows some examples:
(A != 9.0) True if A does not equal 9.0 (A <= “Davies”) True if A is less than or equal to “Davies” (A in [3.4..8.10]) True if A is in range 3.4 to 8.10 (A in [3..8>) True if A is in range 3 to 8, excluding value 8 itself. You can use commas to specify a list of values.
This table shows some examples:
(A in [a,b]) True if A is equal to a or b (A in [a,b,e,f,z]) True if A is equal to a, b, e, f, or z (A in [3..8,15,22]) True if A is in range 3 to 8, 15 or 22 You can logically combine conditional expressions into compound boolean (and, or) or arithmetic (+, -, *, /) expressions.
This table shows some examples:
(A in [3.4..8]) and (B > 2) True if A is in range 3.4 to 8 and B is greater than 2 (B in <”Brown”..”Miller”]) True if B is in range 'Brown' to 'Miller', excluding value 'Brown' itself (((A <> 6) and (B >= 9)) or (C <= 7)) True in these two situations: - A is not equal to 6 and B is greater than or equal to 9
- C is less than or equal to 7
To define null values in a condition, for example for datetime datatype, the NULL value is:
1970-01-01T00:00:00Z