A user who is unsure of the session constraint values can use the HELP SESSION CONSTRAINT command to get a list of the security constraints and associated constraint values for the session.
The HELP SESSION CONSTRAINT command is similar to the HELP SESSION command, but returns additional information about row-level security constraints.
Session Constraint Attributes
The following table shows the attributes returned for each row-level security constraint that applies to the session in addition to the normal HELP SESSION attributes.
| Additional Attributes | Data Type | Nullable? | Description |
|---|---|---|---|
| Constraint_ n_Name | VARCHAR(30) | Yes | The name of a row-level security constraint that applies to a session. If no row-level security constraint applies, the Constraint_n_Name is null. |
| Constraint_ n_Value | Yes | The constraint value for the constraint name that immediately precedes it. If no row-level security constraint applies, the Constraint_n_Value is null. |
|
| Constraint _n Dictionary Name | VARCHAR(128) | No | The attributes shown in this section are based on and supersede the corresponding older Constraint_n_Name attribute, while providing additional functionality. The older attribute is retained for compatibility with existing applications. The system returns this set of attributes for each constraint applicable to the session. For details, see the topics beginning with Object Name and Title Data in HELP Reports. |
| Constraint _n SQL Name | VARCHAR(644) | No | |
| Constraint _n Uescape | VARCHAR(1) | Yes |