When you create a database, it is public by default. Any Ingres user in that instance can connect to the database, but can only create or use tables if they have the necessary privileges. The user who creates a database becomes its database administrator.

Issue this command at the command line:

For example, the following command creates a Unicode-enabled public database named demodb on the local node in the default locations:

To locate a database’s data, checkpoint, journal, or dump files in locations other than the default locations, see the chapter "Using Alternate Locations."