SingleStore DB

Root user behavior

When sync_permissions = on, the root user has some special properties.

  • The root user is not present in SHOW USERS; however, it is still on the node.

  • New root users can be created following the 'root'@'host' pattern; however, they will only be local users.

  • The root grant is root@%.