Configuring user access for the JEE database logger
When you configure the WebSphere® MQ File Transfer Edition Java™ Platform, Enterprise Edition (JEE) database logger, you need user accounts to access WebSphere MQ, your database, and your operating system. The number of operating system users that is required depend on the number of systems you are using to host these components.
About this task
The number and type of user accounts you need to run the Java Platform, Enterprise Edition
(JEE) database logger depend on the number of systems you use. User
accounts are required to access the following three environments:
- Local operating system
- WebSphere MQ
- Database
- Database logger, WebSphere MQ, and the database all on the same system
- You can define a single operating system user for use with all three components. The database logger uses Bindings mode to connect to WebSphere MQ and a native connection to connect to the database.
- Database logger and WebSphere MQ on one system, the database on a separate system
- You create two users for this configuration: an operating system user on the system running the database logger, and an operating system user with remote access to the database on the database server. The database logger uses Bindings mode to connect to WebSphere MQ and a client connection to access the database.
- Database logger on one system, WebSphere MQ on another system, the database on a further system
- You create three users for this configuration: An operating system user to start the application server, a WebSphere MQ user to access the queues and topics being used, and a database server user to access and insert into the database tables. The database logger uses Client mode to access WebSphere MQ and a client connection to access the database.
As an example, the rest of these instructions assume that the user is called ftelog, but you can use any user name, new or existing. Configure the user permissions as follows: