<div>
Hi cuttie,<br />
<br />
DB2 defers to the underlying operating system for user validation. &nbsp;To create a DB2 user, create a user on the server where DB2 is running.<br />
<br />
You can always create additional schemas. &nbsp;The DBA (or anyone with sufficient privilege) would create one with the CREATE SCHEMA statement.<br />
<br />
In most releases of DB2, I believe that a user's default schema is the user's name.<br />
<br />
<br />
Good Luck,<br />
Kent<br />

</div>


Hi cuttie,

DB2 defers to the underlying operating system for user validation.  To create a DB2 user, create a user on the server where DB2 is running.

You can always create additional schemas.  The DBA (or anyone with sufficient privilege) would create one with the CREATE SCHEMA statement.

In most releases of DB2, I believe that a user's default schema is the user's name.


Good Luck,
Kent


<div>
How do I create user on the server?
</div>


<div>
Thanks Kdo. Your comments were useful.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
How to create different user ids in DB2. Also how to create different schema for each user.
</div>
</div>


Hi,
How to create different user ids in DB2. Also how to create different schema for each user.

Different USER ID and Schema in DB2

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.