ALTER USER WITH NO PASSWORD reference
Enterprise:
RBAC provides fine-grained database permissions management.
ALTER USER ... WITH NO PASSWORD removes a user's password.
Syntax
ALTER USER userName WITH NO PASSWORD;
Description
This is the only way to clear a password. WITH PASSWORD '' does not work,
because empty passwords are rejected.
Removing the password does not disable the user. If it still holds a JWK or REST
token it can continue to authenticate with that; to stop access entirely, use
DISABLE or drop its tokens with
DROP TOKEN.
Examples
ALTER USER john WITH NO PASSWORD;
Verify with:
SHOW USER john;
| auth_type | enabled |
|---|---|
| Password | false |
| JWK Token | false |
| REST Token | false |