title: How to resolve pgadmin 4 GRANT syntax error in this query?
body: <p>I am currently busy trying to execute some SQL queries form my demonstratie of a PostgreSQL/Postgis database. However I get a syntax on a certain line in my query.</p>
  
  <p>This query did work in the past on a different computer so I do not see the problem here of why it does not work now:</p>
  
  <pre><code>CREATE ROLE demonstratieuser NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
  CREATE ROLE demonstratieadmin NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
  GRANT demonstratieuser TO demonstratieadmin
  GRANT ALL ON DATABASE demodatabase TO demonstratieadmin
  </code></pre>
  
  <p>It is the following line that has the syntax error on more specifically the Grant part.</p>
  
  <pre><code>GRANT ALL ON DATABASE demodatabase TO demonstratieadmin
  </code></pre>
  
  <p>How do I fix this?</p>
  
  <p>Edit error code:</p>
  
  <pre><code>ERROR:  syntax error at or near "GRANT"
  LINE 4: GRANT ALL ON DATABASE demodatabase TO demonstratieadmin;
          ^
  ********** Error **********
  
  ERROR: syntax error at or near "GRANT"
  SQL state: 42601
  Character: 222
  </code></pre>