PostgreSQL: Setting Up Target User Privileges

To make import into PostgreSQL Database you can utilize the existing user or create a new one.
To create a new user you can execute the statement below:

 CREATE USER tester with PASSWORD 'postgres'; 

Once the user is created you should add the following privileges:

 GRANT USAGE, CREATE ON SCHEMA public TO <target_user>; \\
 GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO <target_user>; \\
 GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO <target_user>; \\

If you have any other questions, please contact us: support@ispirer.com