Altering attributes

Attributes are PostgreSQL’s role flags. Unlike other settings, the list of flags is fixed; there is no option to add or remove any.

Attributes section

It supports following attributes:

Attribute	Keyword
Superuser	SUPERUSER / NOSUPERUSER
Create role	CREATEROLE / NOCREATEROLE
Create DB	CREATEDB / NOCREATEDB
Inherit	INHERIT / NOINHERIT
Login	LOGIN / NOLOGIN
Replication	REPLICATION / NOREPLICATION
Bypass RLS	BYPASSRLS / NOBYPASSRLS

All seven rows always render, depicting clusters where are enabled. If the particular attribute is enabled nowhere, the off symbol is displayed.

Button	Effect
Edit	Per-cluster editor — tick to enable, untick to disable.
Remove	Disables the attribute on every cluster in scope.
Discard	Discards pending changes on that row.

Click on Edit button opens the popup with selection of clusters

Per-cluster attribute editor

Pending changes are visible before you save, through the shared scope-label convention: a pending grant is prefixed with +, a pending revoke turns red and struck through.

When executing all of a cluster’s attribute changes are combined into a single ALTER ROLE … WITH keyword keyword … query, so enabling LOGIN and disabling SUPERUSER turns into single statement, not two.