_progress._sec-granted-role-condition

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.


Table details

Area Schema Area
Dumpname _sec-granted-role-condition
Label ?
Val.exp ?
Val.msg

Fields

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

Indexes

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