create user and assign role to postgresql code example

Example 1: postgresql change user role grant

=# ALTER USER librarian WITH SUPERUSER;
ALTER ROLE

Example 2: how to add user to role postgresql

GRANT group_role TO role1, ... ;
REVOKE group_role FROM role1, ... ;