Note
- This variable is available starting with V4.3.1 in V4.3.x.
- This variable is available starting with V4.2.3 in V4.2.x.
Description
activate_all_roles_on_login specifies whether to automatically activate all roles upon login.
Applicability
This variable applies only to OceanBase Database in MySQL-compatible mode.
Privilege requirements
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to obtain the value of a Global system variable.Modify variables
The
systenant can directly modify the value of a Global system variable.A MySQL user tenant must have the
SUPERorALTER SYSTEMprivilege to modify the value of a Global system variable.
Attributes
Attribute |
Description |
|---|---|
| Type | Boolean |
| Default value | 0 |
| Value range |
|
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Enable all roles upon login.
obclient> SET GLOBAL activate_all_roles_on_login=ON;