MineMarket Database Configuration

Important: This section assumes that a database server has been installed and correctly configured with associated permissions, and that a database has been set up to contain the MineMarket database tables.

Contact your Network Administrator or Datamine representative for configuration information to network databases.

MineMarket uses the MineMarket database.

Before MineMarket can be configured, the necessary tables need to be set up in the MineMarket database.

Database Server Compatibility

The MineMarket database is compatible with both Microsoft SQL Server and Oracle Server.

Database User Role Membership / Privileges

SQL Server

If the MineMarket database authentication uses integrated security, users must be added in the DBMS for the MineMarket database. See the following activities for details of which users must be added:

Run the Full SQL Script to Create the MineMarket Tables (has information about MineMarket Client users)
Configure the Logon User for each MineMarket Service

The SQL Server user that is the logon user for the MineMarket Service requires the following role membership: db_owner.

All other SQL Server users that access the MineMarket database require the following role membership: public.

Oracle

The Oracle user that is the logon user for the MineMarket Service requires the following privileges: Connect and Resource.

So, if a user is created as follows:

Create user MineMarket identified by MineMarket;

Then the following privileges must be assigned to that user for MineMarket to work properly:

Grant Connect, Resource to MineMarket;

The Resource privilege enables the user to manage all objects necessary to run the system (Tables, Views, Procedures, and so on).