Skip to main content

Documentation Index

Fetch the complete documentation index at: https://private-7c7dfe99-page-updates.mintlify.app/llms.txt

Use this file to discover all available pages before exploring further.

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