Different USER ID and Schema in DB2

How to create different user ids in DB2. Also how to create different schema for each user.
Who is Participating?
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:
Depends on the server.

If it's Windows, start with My Computer / Manage.

If it's linux or unix, the adduser (or useradd) command will create a new user.  You can specify the password when you create the user or use the passwd command to change/set it.

If it's an OS/2 or AS/400 server, we'll have to get someone else to chime in as I'm not a mainframe type.

Kent OlsenData Warehouse Architect / DBACommented:
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,
cuttieveenzAuthor Commented:
How do I create user on the server?
cuttieveenzAuthor Commented:
Thanks Kdo. Your comments were useful.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.