The example environment consists of four idents:

In the MIMER_STORE schema most of the objects supported by Mimer SQL are introduced: collations, databanks, domains, idents, sequences, synonyms, tables and views. They are used to demonstrate some of the functionality that is available - constraints; primary, unique and foreign keys; secondary indices, NOT NULL, default values, and column and table check clauses. The schema also includes examples of PSM routines and triggers. This schema contains the following tables: currencies, countries, categories, formats, producers, products, images, items, customers, orders,order_items, stop_words. As the MIMER_STORE user creates the other users he/she can change the password of MIMER_ADM, MIMER_USR, and MIMER_WEB. Because of this it is important for you to remember what password you give MIMER_STORE.

The other idents created show how different users can be given varying level of access depending on who is accessing the system. The user ident MIMER_ADM has access to most database objects and is also allowed to update them. The MIMER_USR ident has read access to the most objects, but cannot make any changes. Finally, the MIMER_WEB ident, has very restricted access and may only see parts of the database.

The passwords must be at least one character. Passwords are case sensitive in Mimer SQL.