Eine Einführung in

SQL

Create a new user.

PostgreSQL
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.