Specify Billboard Server Settings

The billboard server settings can be modified to reduce the demand of SQL queries made upon the server by using a count to indicate when new records are available to populate a billboard, and to add security to ensure that the SQL statements that can be run on the database are of a read-only nature. Datamine recommends configuring a read-only user for billboards.

Copy

Example Oracle script for a read-only user

CREATE USER "READONLYBB" PROFILE "DEFAULT"
IDENTIFIED BY "bulktrak" DEFAULT TABLESPACE "USERS"
ACCOUNT UNLOCK;
GRANT ALTER SESSION TO "READONLYBB";
GRANT select ANY TABLE TO "READONLYBB";
GRANT "CONNECT" TO "READONLYBB";
GRANT "Select_CATALOG_ROLE" TO "READONLYBB";
commit;

Security Note: You need the Allow server engine settings security right in the Options user group security rights group for this activity.

Activity Steps

  1. Open the Billboard Options screen.
  2. Select whether to Allow Billboard Count. If checked, a count indicates that new records are available for billboards that are linked on the Task Pane tab of the Navigation Pane. You can override this setting for an individual billboard. To display a billboard count, the billboard must have the following configuration:
    • A SQL query
    • No parameters
    • Pivot Data set to False
    • Allow Auto Count set to True
  3. If Allow Billboard Count is checked, enter the Billboard Count Interval.
  4. To configure a read-only user for billboards:
    1. Set Use Primary Connection to False.
    2. Enter the Read Only UserID. This MineMarket database user and password need to be set up already by the database administrator.
    3. Enter the Read Only Password.
    4. If the MineMarket database is hosted on an Oracle server, enter the Schema Name.
  5. Click OK.

    Note: MineMarket saves the changes from this screen automatically. This saving does not include any unsaved changes made on any other screens.