create role and grant privileges in postgres code example

Example: how to give access to database in postgresql server to another user

GRANT permissions ON DATABASE dbname TO username;