WebSphere WebSphere Application Server Express, Version 6.0.x Operating Systems: AIX, HP-UX, Linux, Solaris, Windows

Creating users and schemas in the database

Use this task to create a schema for the data store.

Before you begin

Before you begin this task, refer to Creating the database

Why and when to perform this task

All the tables in a data store are stored in a single schema.

Steps for this task

  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 data store. If you are using the Informix RDBMS, configure a separate database instance for each messaging engine.
  2. Refer to Database privileges for information about the authorities that you require to access the data store.
Related reference
Database privileges

Task topic

Terms of Use | Feedback

Last updated: 2 Aug 2005
http://publib.boulder.ibm.com/infocenter/ws60help/index.jsp?topic=/com.ibm.websphere.pmc.express.doc\tasks\tjm0070_.html

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