Note
- For OceanBase Database V4.3.x, this variable was introduced in OceanBase Database V4.3.1.
- For OceanBase Database V4.2.x, this variable was introduced in OceanBase Database V4.2.3.
Description
activate_all_roles_on_login specifies whether to automatically activate all roles upon logon by default.
Applicability
This variable is applicable to only OceanBase Database in MySQL mode.
Limitations
Query the variable
In the
systenant or a user tenant, you can execute theSHOW VARIABLESstatement to query the variable at the global level or query theinformation_schema.GLOBAL_VARIABLESview (in MySQL mode) for the variable at the global level.Modify the variable
In the
systenant, you can directly change the value of the variable at the global level.In a MySQL user tenant, you must have the
SUPERorALTER SYSTEMprivilege to change the value of the variable at the global level.
Attributes
| Attribute | Description |
|---|---|
| Type | Boolean |
| Default value | 0 |
| Value range |
|
| Effective scope | Global |
| Modifiable | Yes. You can use the SET statement to modify the variable. |
Example
Specify to automatically activate all roles upon logon by default.
obclient> SET GLOBAL activate_all_roles_on_login=ON;