{
    "mode": "man",
    "parameter": "ALTER_USER",
    "section": "7",
    "url": "https://www.chedong.com/phpMan.php/man/ALTER_USER/7/json",
    "generated": "2026-07-05T13:06:38Z",
    "synopsis": "ALTER USER rolespecification [ WITH ] option [ ... ]\nwhere option can be:\nSUPERUSER | NOSUPERUSER\n| CREATEDB | NOCREATEDB\n| CREATEROLE | NOCREATEROLE\n| INHERIT | NOINHERIT\n| LOGIN | NOLOGIN\n| REPLICATION | NOREPLICATION\n| BYPASSRLS | NOBYPASSRLS\n| CONNECTION LIMIT connlimit\n| [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL\n| VALID UNTIL 'timestamp'\nALTER USER name RENAME TO newname\nALTER USER { rolespecification | ALL } [ IN DATABASE databasename ] SET configurationparameter { TO | = } { value | DEFAULT }\nALTER USER { rolespecification | ALL } [ IN DATABASE databasename ] SET configurationparameter FROM CURRENT\nALTER USER { rolespecification | ALL } [ IN DATABASE databasename ] RESET configurationparameter\nALTER USER { rolespecification | ALL } [ IN DATABASE databasename ] RESET ALL\nwhere rolespecification can be:\nrolename\n| CURRENTROLE\n| CURRENTUSER\n| SESSIONUSER",
    "sections": {
        "NAME": {
            "content": "ALTERUSER - change a database role\n",
            "subsections": []
        },
        "SYNOPSIS": {
            "content": "ALTER USER rolespecification [ WITH ] option [ ... ]\n\nwhere option can be:\n\nSUPERUSER | NOSUPERUSER\n| CREATEDB | NOCREATEDB\n| CREATEROLE | NOCREATEROLE\n| INHERIT | NOINHERIT\n| LOGIN | NOLOGIN\n| REPLICATION | NOREPLICATION\n| BYPASSRLS | NOBYPASSRLS\n| CONNECTION LIMIT connlimit\n| [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL\n| VALID UNTIL 'timestamp'\n\nALTER USER name RENAME TO newname\n\nALTER USER { rolespecification | ALL } [ IN DATABASE databasename ] SET configurationparameter { TO | = } { value | DEFAULT }\nALTER USER { rolespecification | ALL } [ IN DATABASE databasename ] SET configurationparameter FROM CURRENT\nALTER USER { rolespecification | ALL } [ IN DATABASE databasename ] RESET configurationparameter\nALTER USER { rolespecification | ALL } [ IN DATABASE databasename ] RESET ALL\n\nwhere rolespecification can be:\n\nrolename\n| CURRENTROLE\n| CURRENTUSER\n| SESSIONUSER\n",
            "subsections": []
        },
        "DESCRIPTION": {
            "content": "ALTER USER is now an alias for ALTER ROLE.\n",
            "subsections": []
        },
        "COMPATIBILITY": {
            "content": "The ALTER USER statement is a PostgreSQL extension. The SQL standard leaves the definition of\nusers to the implementation.\n",
            "subsections": []
        },
        "SEE ALSO": {
            "content": "ALTER ROLE (ALTERROLE(7))\n\n\n\nPostgreSQL 14.23                                2026                                   ALTER USER(7)",
            "subsections": []
        }
    },
    "summary": "ALTERUSER - change a database role",
    "flags": [],
    "examples": [],
    "see_also": [
        {
            "name": "ALTERROLE",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/ALTERROLE/7/json"
        },
        {
            "name": "USER",
            "section": "7",
            "url": "https://www.chedong.com/phpMan.php/man/USER/7/json"
        }
    ]
}