MOVE

Documentation for MOVE access entity statement

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

Syntax:

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:

MOVE USER test TO local_directory

MOVE ROLE test TO memory

Related: CREATE USER, CREATE ROLE, SHOW