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