| DB | Areas | X-idx | Tables | Sequences | <- _sec-granted-role | _sec-role -> | HtmlDict 11 |
This table is not supported for SQL and is only applicable to application defined roles, i.e. roles that do not begin with an underscore. This will not be checked for internal roles. This table extends the functionality for PVM (4GL client) specific application roles by facilitating the allocation of the role according to a pre-defined set of conditions. The role will therefore only be granted if all of the conditions are true using a logical AND operator. The failing of a grant condition is the equivalent of revoking the role. Example grant conditions could include only granting the role if the user authenticates to a specific login company, accesses a specific module of the application, or gains access between certain operating hours, etc. The grant condition attributes could be automatically checked at runtime during authentication against the authenticated credentials and the list of associated roles adjusted accordingly.
| Area | Schema Area |
|---|---|
| Dumpname | _sec-granted-role-condition |
| Label | ? |
| Val.exp | ? |
| Val.msg |
| Order | Field Name | x | Label | Datatype | Format | Initial | Mand | Description |
|---|---|---|---|---|---|---|---|---|
| 3 | _Conditional-attribute | X | Conditional attribute | character | X(70) | D: This is an attribute of the authenticated credentials to check at runtime to determine whether the granting of this role should in fact be revoked. | ||
| 5 | _Conditional-value | X | Conditional value | character | X(500) | V: e sz 70 BY 8 sv MAX-CHARS 500 D: This is the value of the specified attribute of the authenticated credentials to check at runtime to determine whether the granting of this role should in fact be revoked. |
||
| 6 | _Custom-condition-detail | X | Custom grant detail | character | X(500) | V: e sz 70 BY 8 sv MAX-CHARS 500 D: This is a custom field to specify additional role condition details. |
||
| 2 | _Granted-role-guid | X | Granted role guid | character | X(28) | D: This is a globally unique identifier (guid) to identify this role membership record that this grant condition applies to. | ||
| 4 | _Logical-operator | X | Logical operator | character | X(10) | D: This is the logical operator to apply to the attribute value in order to perform the validation. Supported logical operators are; == equality != not equal to > greater than >= greater than or equal to < less than <= less than or equal to |
| Index name | Flags | Fields | Datatype |
|---|---|---|---|
| _Granted-role-guid | P U | _Granted-role-guid (+) | character |
| _Conditional-attribute (+) | character | ||
| _Logical-operator (+) | character | ||
| _Conditional-value (+) | character | ||
| _Conditional-attribute | _Conditional-attribute (+) | character |
| + = Ascending | - = Descending | P = Primary | U = Unique | I = Inactive | W = Wordindex |
| generated 3-3-2025 10:55 |