User Management Admin Web supports MS ACCESS, MS SQL und Oracle databases.
User Management Admin Web is able to create the data model automatically.
Prerequisites for this are
•an existing database schema,
•a database user with the right to create and edit tables (Insert, Update, Delete, Select). It is recommended to use the schema owner user for this. The user also needs the right for CREATE ANY PROCEDURE and ALTER ANY PROCEDURE.
•a correctly configured database connection in the web.config file of User Management Admin Web
Start User Management Admin Web in the browser – the application will guide you through the database creation/upgrade wizard (User Management Admin Web is able to either create the data model from scratch or to upgrade the data model if it out of date).
Note: If you want to delete all data and the data model from your database, you can use the SQL drop scripts. See directory ‘Software\User Management Admin Web\Database’ for database scripts