ALTER USER WITH PASSWORD reference
Enterprise:
RBAC provides fine-grained database permissions management.
ALTER USER ... WITH PASSWORD sets a user's password.
Syntax
ALTER USER userName WITH PASSWORD password;
Description
Setting a password replaces any existing one. Empty passwords are rejected, so
WITH PASSWORD '' cannot be used to clear one; use
WITH NO PASSWORD instead.
Examples
ALTER USER john WITH PASSWORD '1m@re@lh@cker';
Verify with:
SHOW USER john;
| auth_type | enabled |
|---|---|
| Password | true |
| JWK Token | false |
| REST Token | false |