title: How to create a user in postgres and to give grantall privileges
body: <p>I'm new to PostgreSQL and I have created a postgres instance in the AWS RDS and I have also created a new user. Now I would like to grant all privileges to that user for creating new databases and to perform all admin operations.</p>
  
  <p>I have found the below query to do that but it was providing access only to a particular database and that user is unable to create a new database.</p>
  
  <pre><code>GRANT ALL ON DATABASE workflow TO cnwrkstag;
  </code></pre>
  
  <p>I have also tried to provide access as a super user of RDS but I'm getting an error as I am unable to so because it should be a super user.</p>
  
  <p>Can anyone help me with this?</p>