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 login by default.
Applicability
This variable is applicable to only OceanBase Database in MySQL-compatible 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-compatible 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 login by default.
obclient> SET GLOBAL activate_all_roles_on_login=ON;