SQLZOO, Create a new user.

Ingres
Give the new user permission to connect and to create their own tables etc.	create user scott with password = 'tiger' grant all on database scott to scott grant access on database gisq to scott
Specific to Ingres
Create a user from the operating system - (for example `adduser scott`). Have that user run the command: source /home/ingres/ingIIbash Create a database for the user using the os command `createdb scottdb` issue the commands into database iidbdb as user `ingres` su - ingres source ~/.ingIIbash createdb scott sql iidbdb You should come out of the sql application before you attempt to log in as scott

SQLzoo.net