Specifying User Name and Password (Using CREATE DATABASE)

Go Up to Using CREATE DATABASE

If provided, the user name and password are checked against valid user name and password combinations in the security database on the server where the database will reside. Only the first eight characters of the password are significant.

Important: Windows client applications must create their databases on a remote server. For these remote connections, the user name and password are not optional. Windows clients must provide the USER and PASSWORD options with CREATE DATABASE before connecting to a remote server.

The following statement creates a database with a user name and password:

CREATE DATABASE 'employee.ib' USER 'SALES' PASSWORD 'mycode';