{$page}

This page details how to create the JDF user in your database that is then used by Cyrious' JDF monitor program.

Overview

The JDF user in SQL Server is used by the JDF Monitor program to access the Control database for information necessary to build the JDF job ticket. This requires read-only access to the following tables:

The JDF Monitor also access the queue to orders that need a job ticket created. This requires read-write access to the following table:

In order to minimize your security exposure, no additional access should be given to the JDF user.

Steps

To create the JDF user, open the SQL Server Management Studio and connect to your database. Then execute the following query, checking first that the database name and password supplied are correct for your scenario.

code_formatsql

– first create the SQL user in SQL Server master table

create login JDFMonitor 

  with password = 'JDFRules',
  default_database = CyriousTest,
  default_language = English,
  check_policy = OFF

;

– now switch to the database

use StoreData

;

– and create a user for this database linked to the one just created

create user JDFMonitor 

FOR LOGIN JDFMonitor

;

code

Creating a Database Role

For security purposes, you should create a database role that provides only SELECT access to the read-only tables, and SELECT, INSERT, and UPDATE access to the READ-WRITE tables. How this is done varies with each version of SQL Server, but from the console it is usually under the Security setting under the database.

See Also