Run the Full SQL Script to Create the MineMarket Tables

Use this activity to run the generated SQL script to create the MineMarket database tables and associations.

The following table summarises the security configuration required for MineMarket Client users. The configuration depends on the database authentication configured for the MineMarket Server.

	MineMarket Database Authentication
	Integrated Security	Basic Authentication (User Name and Password)
MineMarket Client users (eg MyDomain\MMUser1, MyDomain\MMUser2)	Add all users, either individually or as an active directory user group, as database users in the DBMS. Add all users individually to appropriate MineMarket user groups.	Add all users individually to appropriate MineMarket user groups.

Database users may also need to be configured for services. See Configure the Logon User for each MineMarket Service.

Note: This activity should be performed by the Database Administrator for the site.

Activity Steps

SQL Server

1. Create a new database.
2. Run the SQL script in a SQL Server database scripting environment against the new database.
3. Create appropriate logins for the MineMarket database.

Oracle

1. Create a new schema.
2. Run the SQL script in an Oracle database scripting environment against the new schema.
3. Create appropriate logins for the MineMarket database.

Note: MineMarket can be configured to have users log on with Windows authentication, and this is recommended for all installations.