Back to Clickhouse

MOVE access entity statement

docs/en/sql-reference/statements/move.md

26.4.1.1-new465 B
Original Source

MOVE access entity statement

This statement allows to move an access entity from one access storage to another.

Syntax:

sql
MOVE {USER, ROLE, QUOTA, SETTINGS PROFILE, ROW POLICY} name1 [, name2, ...] TO access_storage_type

Currently, there are five access storages in ClickHouse:

  • local_directory
  • memory
  • replicated
  • users_xml (ro)
  • ldap (ro)

Examples:

sql
MOVE USER test TO local_directory
sql
MOVE ROLE test TO memory