default_authentication_plugin

Overview

default_authentication_plugin specifies the default authentication plugin for new users.

Privilege requirements

• Query variables

  Both the sys tenant and all user tenants can use the SHOW VARIABLES statement, or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (in Oracle-compatible mode) and the information_schema.GLOBAL_VARIABLES view (in MySQL-compatible mode), to view the values of global system variables.

• Modify variables

  • The sys tenant can directly modify the values of global system variables.

  • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the values of global system variables.

  • Oracle user tenants must have the ALTER SYSTEM privilege to modify the values of global system variables.

Attributes

Configuration example

Set the default authentication plugin for new users to the caching_sha2_password plugin.

obclient> SET default_authentication_plugin = 'caching_sha2_password';