postgres grant sql script new user code example

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

GRANT permissions ON DATABASE dbname TO username;