Eine Einführung in

SQL

Create a new user.

PostgreSQL
Give the new user permission to connect and to create their own tables etc.	CREATE USER scott WITH PASSWORD 'tiger'; CREATE DATABASE scott; GRANT ALL ON DATABASE scott to scott;
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.