Description\n-----------\n\nOnly one role can be current at a time. Executing SET ROLE replaces the current role; it does not add to a list of current roles. This is SQL Standard compliant behavior which differs from MySQL, where you may have several current roles at a time.\n\nThe SET ROLE statement switches the current role for the session, enabling its associated permissions. To have no current role, set NONE.\n\nIf a role that doesn't exist, or to which the user has not been assigned, is specified, an ERROR 1959 (OP000): Invalid role specification error occurs.\n\nAn automatic SET ROLE is implicitly performed when a user connects if that user has been assigned a default role. See SET DEFAULT ROLE.\n\nExamples\n--------\n\n--Checking the current role status\nSELECT CURRENT_ROLE;\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/account-management-sql-statements/set-role