Posted on 2013-12-29
You need to be logged in to psql as an admin, connected to the correct database.
create user mynewuser with password 'mynewpassword'; grant connect on database mydatabase to mynewuser; grant select on all tables in schema public to mynewuser;
Tags: postgresql