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

specific or database-specific, respectively. The ALTER ROLE and ALTER DATABASE commands are used ... server as an ALTER ROLE command. This makes sure that the new password does

ALTER DATABASE ... SET ... and ALTER ROLE ... IN DATABASE ... SET ... commands that mention this database. Access

ALTER DATABASE ... SET ... and ALTER ROLE ... IN DATABASE ... SET ... commands that mention this database. Access

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