Mimer SQL on Windows
Create Example Users

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.

See Also