SET ROLE

SET ROLE {DEFAULT | NONE | role [,...] | ALL | ALL EXCEPT role [,...]}

SET DEFAULT ROLE {NONE | role [,...] | ALL | ALL EXCEPT role [,...]} TO {user|CURRENT_USER} [,...] [ON CLUSTER cluster_name]

SET DEFAULT ROLE role1, role2, ... TO user

SET DEFAULT ROLE ALL TO user

SET DEFAULT ROLE NONE TO user

SET DEFAULT ROLE ALL EXCEPT role1, role2 TO user

SET DEFAULT ROLE role1 TO user ON CLUSTER my_cluster
SET DEFAULT ROLE ON CLUSTER my_cluster role1 TO user