postgresql grant insert,select on database code example
Example: how to give access to database in postgresql server to another user
GRANT permissions ON DATABASE dbname TO username;
GRANT permissions ON DATABASE dbname TO username;