SQLzoo.net

Create a new user.

Postgres
Give the new user permission to connect and to create their own tables etc.


Specific to Postgres
If scott is the name of a Unix account there is no problem - otherwise you must insert the following line before the default lines
local scott template1 password
to the file /var/lib/postgres/data/pg_hba.conf this allows postgres user scott to connect to database template1.

Related links:

  • USERS