For AI agents: the complete documentation index is at llms.txt. Every page is also available as markdown by appending .md to its URL, or by sending an Accept: text/markdown request header.

ALTER USER DISABLE reference

Enterprise:

RBAC provides fine-grained database permissions management.

Learn moreFree trial

ALTER USER ... DISABLE turns off a user account without deleting it.

Syntax​

ALTER USER userName DISABLE;

Description​

A disabled user keeps its permissions, group memberships and tokens; it simply cannot authenticate until it is enabled again. Existing sessions are not the subject of this statement, so disable is not a way to evict a connected user.

To remove a user permanently instead, use DROP USER.

Examples​

ALTER USER john DISABLE;

Verify with SHOW USERS, which reports false in its enabled column.

See also​