-- with_options
alter role r with superuser;



-- rename
alter role r rename to newname;
alter role r rename to current_user;

-- set_config
alter role r set param = 'value';
alter role r set param to 'value';
alter role r set param to default;

-- set_config_from_current
alter role r set param from current;

-- reset_config
alter role r reset param;

-- reset_all
alter role r reset all;

-- in_database
alter role r in database d set param to 'value';

-- using_current_user
alter role current_user with nologin;

-- for_all_roles
alter role all reset all;

