ALTER_USER(7pg15)

✨ ALTER USER ✨ (that's the ALTER_USER page from the PostgreSQL 15.19 docs, bestie 💅)

okay so real talk — this one's short and sweet, and the tea is that ALTER USER is literally just ALTER ROLE wearing a different outfit. no cap. but let's get into it anyway 🫶

---

🎀 NAME 🎀

ALTER_USER — change a database role

like, it changes a role. that's the whole vibe. 🌸

---

🦋 SYNOPSIS 🦋

ALTER USER role_specification [ WITH ] option [ ... ]

where option can be:

      SUPERUSER | NOSUPERUSER
    | CREATEDB | NOCREATEDB
    | CREATEROLE | NOCREATEROLE
    | INHERIT | NOINHERIT
    | LOGIN | NOLOGIN
    | REPLICATION | NOREPLICATION
    | BYPASSRLS | NOBYPASSRLS
    | CONNECTION LIMIT connlimit
    | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
    | VALID UNTIL 'timestamp'

ALTER USER name RENAME TO new_name

ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT }
ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT
ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] RESET configuration_parameter
ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] RESET ALL

where role_specification can be:

    role_name
  | CURRENT_ROLE
  | CURRENT_USER
  | SESSION_USER

look at all those options, it's giving menu at a really good restaurant 😭 every single one is there, don't worry, i would never gatekeep 💖

---

🔥 DESCRIPTION 🔥

okay so the whole entire point: ALTER USER is now an alias for ALTER ROLE. that's it. that's the sentence. slay, iconic, minimal, periodt 👑

(if you actually wanna know what all those options do, the ALTER ROLE page is your bestie — see SEE ALSO below, i gotchu 🫶)

---

🌈 COMPATIBILITY 🌈

so this is the part where we find out it's ✨special✨:

• the ALTER USER statement is a PostgreSQL extension — it's not a standard thing, it's our thing 💅
• the SQL standard leaves the definition of users to the implementation, which is honestly such a "figure it out yourself" move of them 🙈

so yeah, don't expect other databases to know what you're talking about. main character PostgreSQL energy only. 🦋

---

🌟 SEE ALSO 🌟

• ALTER ROLE (ALTER_ROLE(7)) — the actual one, the blueprint, the original 👑

---

ok bestie here's your gentle reminder: this page is genuinely just a redirect in disguise. if you were hoping for a deep lore drop, the ALTER_ROLE(7) page is where the real content lives. no crumbs here, only vibes 💀

---

and that's the whole page!! 💖✨🎀 this lil beauty came straight out of the PostgreSQL 15.19 documentation, dated 2026, and it's filed under ALTER USER(7) — mwah, go forth and alter some users, you got this 🧚‍♀️🍓