Eine Einführung in


Create a new user.

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

Specific to PostgreSQL
If scott is the name of a Unix account there is no problem - otherwise you must add the line
local template1 password
to the file /usr/lib/postgres/data/pg_hba.conf this allows any user with a postgres account to connect to database template1.