MOVE

View as MarkdownEdit this pageReport an issueSet up docs MCP

该语句用于将访问实体从一个访问存储移动到另一个访问存储。

语法：

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

目前，ClickHouse 中有五种访问控制存储：

local_directory
memory
replicated
users_xml (ro)
ldap (ro)

示例：

MOVE USER test TO local_directory

MOVE ROLE test TO memory

相关： CREATE USER、CREATE ROLE、SHOW