title: psql: permission denied for database "dbname" ("User does not have CONNECT privilege.") / "unrecognized role option 'connect'"
body: <p>when I try to login to my database with psql, doing this:</p>
  
  <pre><code>psql dbname --username=qgis --password
  &gt;&gt;(prompts for password, entered password)
  psql: FATAL:  permission denied for database "gisdatabase"
  DETAIL:  User does not have CONNECT privilege.
  </code></pre>
  
  <p>I've searched around on Google for information on this simple issue but haven't found anyone directly talking about this.</p>
  
  <p>I've tried doing this:</p>
  
  <pre><code>psql dbname
  &gt;&gt;ALTER ROLE qgis WITH CONNECT;
  </code></pre>
  
  <p>But got this error:</p>
  
  <pre><code>ERROR:  unrecognized role option "connect"
  </code></pre>
  
  <p>So once again, here I am, asking yet another question on stackoverflow. Thanks for your time folks</p>