Search

NAME ALTER_ROLE - change a database role SYNOPSIS ALTER ROLE role_specification [ WITH ] option [ ... ] where ... password ' | PASSWORD NULL | VALID UNTIL ' timestamp ' ALTER ROLE …

accepted for backwards compatibility. NOTES Use ALTER ROLE to change the attributes of a role ... ROLE can be modified by later ALTER ROLE commands. The preferred

USER is now an alias for ALTER ROLE . COMPATIBILITY The ALTER USER statement ... users to the implementation. SEE ALSO ALTER ROLE ( ALTER_ROLE

equivalent to renaming the role with ALTER ROLE . PARAMETERS group_name The name ... ALSO GRANT (7), REVOKE (7), ALTER ROLE ( ALTER_ROLE

specified by the command-line options, ALTER ROLE , or ALTER DATABASE , if any such settings ... specified by the role's ALTER ROLE settings; this only happens during login. SET RO…

ALSO CREATE ROLE ( CREATE_ROLE (7)), ALTER ROLE ( ALTER_ROLE (7)), SET ROLE ( SET_ROLE

rather than to a database; see ALTER ROLE ( ALTER_ROLE (7)). Role-specific settings override

NAME ALTER_RULE

NAME ALTER_ROUTINE

NAME ALTER_TABLE

NAME ALTER_VIEW

NAME ALTER_TYPE

NAME ALTER_INDEX

NAME ALTER_SERVER

NAME ALTER_DOMAIN

NAME ALTER_POLICY

NAME ALTER_SCHEMA

NAME ALTER_SYSTEM

NAME ALTER_TRIGGER

NAME ALTER_SEQUENCE