WebSphere Message Brokers
File: ap11690_
Writer: Stephanie J Strugnell

Task topic

This build: July 31, 2007 21:34:55

Database security

The service user ID for the brokers must be authorized to access databases:
  • Each broker service user ID must be authorized for create and update tasks on the database that contains the broker internal tables.

    In addition to the broker service user ID, this also applies to any data source user ID if defined (using mqsicreatebroker command), or to any user ID specified for a data source by use of the mqsisetdbparms command.

Derby databases, created either by the Default Configuration wizard or by the mqsicreatedb command on Windows, do not require security authorization. Refer to Using Derby databases on Windows for more information.

Database security is defined and modified using various commands dependent upon the database that is being used. See the following:

For information relating to specific databases see:

Related concepts
Security overview
Authorization to access runtime resources
Using Derby databases on Windows
Related tasks
Oracle: granting and revoking user access to databases
SQL Server: granting and revoking user access to databases
Sybase: granting and revoking user access to databases
Related reference
ACL permissions
mqsicreatebroker command
mqsichangebroker command
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:34:55

ap11690_ This topic's URL is: