ALTER SERVICE ACCOUNT WITH NO PASSWORD reference
Enterprise:
RBAC provides fine-grained database permissions management.
ALTER SERVICE ACCOUNT ... WITH NO PASSWORD removes a service account's
password.
Syntax
ALTER SERVICE ACCOUNT serviceAccountName 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 account. 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 SERVICE ACCOUNT client_app WITH NO PASSWORD;
Verify with:
SHOW SERVICE ACCOUNT client_app;
| auth_type | enabled |
|---|---|
| Password | false |
| JWK Token | true |
| REST Token | false |