psql connect to database as another user code example

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

GRANT permissions ON DATABASE dbname TO username;