WebSphere WebSphere Application Server Network Deployment, Version 6.1.x Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

Creating users and schemas in the database

After you have created a database, you need to create the schema in which all tables in the data store are held.

Before you begin
Before you begin this task, create the database for your messaging engine.
About this task

All the tables in the data store must be stored in the same schema. If the schema names are different, a database can hold more than one data store. Although every messaging engine uses the same table names, its relationship with the schema gives each messaging engine exclusive use of its own tables.

To connect to WebSphere Application Server, the database administrator must create at least one user. The number of user IDs you need depends on the database you use:
  • If you are using Derby, DB2 or Oracle, then the messaging engine can be configured to create any additional schemas that may be required for other data stores. That is, if you only create one user, it can have one to many relationships with the schemas in the database. Refer to Configuring a messaging engine to use a data source for details.
  • For all other types of databases, the schema must be created prior to starting the messaging engines that depend on them.

If the user ID can be configured to use multiple schemas then only that user ID is needed for all messaging engines. Otherwise the user is restricted to using tables in its own schema. In this case there can only be one user ID per schema.

Procedure

  1. Refer to the documentation for your chosen relational database management system (RDBMS) for more information about how to create users and schema. With DB2 databases, you create users and schema in separate steps. With the other databases, there is a one-to-one relationship between a schema and a user.
    Informix tip: The one-to-one relationship between a messaging engine and a data store means that every messaging engine must have its own database tables. If you are using the Informix RDBMS, configure a separate database instance for each messaging engine. Problems have been observed in this environment when the data stores for multiple messaging engines were configured to use separate schemas in the same database.
  2. Refer to Database privileges for information about the authorities that you require to access the data store.
Related tasks
Creating the database
Related reference
Database privileges

Task topic

Terms of use | Feedback


Timestamp icon Last updated: 26 February 2009
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.pmc.nd.multiplatform.doc/tasks/tjm0070_.html

Copyright IBM Corporation 2004, 2009. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)