alter-system-set.md 1009 B
title: "ALTER SYSTEM SET"
description: "ALTER SYSTEM SET globally modifies the value of a configuration parameter."
menu:
main:
parent: 'commands'
ALTER SYSTEM SET globally modifies the value of a configuration parameter.
To see the current value of a configuration parameter, use SHOW.
Syntax
{{< diagram "alter-system-set-stmt.svg" >}}
| Field | Use |
|---|---|
| name | The name of the configuration parameter to modify. |
| value | The value to assign to the configuration parameter. |
| DEFAULT | Reset the configuration parameter's default value. Equivalent to ALTER SYSTEM RESET. |
{{% configuration-parameters %}}
Privileges
The privileges required to execute this statement are:
{{< include-md file="shared-content/sql-command-privileges/alter-system-set.md" >}}