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 two databases:
- MineMarket database
Before MineMarket can be configured, the necessary tables need to be set up in the MineMarket database.
- MineMarket Data Mart database (only required for the MineMarket Information Services)
The MineMarket Data Mart database is created automatically when the MineMarket Data Mart Service is run for the first time.
Database Server Compatibility
The MineMarket database is compatible with both Microsoft SQL Server and Oracle Server.
The MineMarket Data Mart database is only compatible with Microsoft SQL Server.
The MineMarket Information Services can be configured to use:
- A MineMarket Database and a MineMarket Data Mart database on Microsoft SQL Server
- A MineMarket Database on Oracle Server and a MineMarket Data Mart database on SQL 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.
The SQL Server user that is the logon user for the MineMarket Information Services requires either the dbcreator server role, or the following role membership for the Data Mart database: 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).
