Azure Database for PostgreSQL – Hyperscale (Citus) – User role management is now available
Published date: 13 November, 2019
Now in general availability, user role management enables management of Postgres user roles on Hyperscale (Citus) server group nodes in addition to "citus" and other built-in roles. You now have the ability to create and delete additional user roles as well as reset passwords for these roles in the Azure portal. All Postgres roles defined are valid on all coordinator and worker nodes in the Hyperscale (Citus) server group. Role privileges can be modified using standard Postgres commands and tools such as PgAdmin or psql. System-wide GRANTs can be propagated to all nodes using run_command_on_workers() helper function.