select rolname from pg_roles;

create role role_name;
drop role role_name;
grant role_name to user_name;
revole role_name from user_name;

GRANT ALL PRIVILEGES ON DATABASE database_name TO role_name WITH GRANT OPTION;

									  List of databases
   Name    |  Owner   | Encoding |                     Access Privileges
-----------+----------+----------+-----------------------------------------------------------
 d2        | ken      | UTF8     | {=Tc/ken,ken=CTc/ken,dbo=C*T*c*/ken}