DB2 : DB user creation steps.
In Db2, you don’t directly create database users inside the database. Db2 relies on operating system (OS) or LDAP users for authentication — and then you grant them access inside the database. Step 1. Create the OS user On Linux/Unix using root: For example:- useradd -d /opt/manoj/dbdata/testdb2 testdb2 passwd testdb2 Step 2. Connect to the Db2 instance as instance owner Example (if instance owner is db2inst1): su - db2inst1 db2 connect to db2db Step 3. Grant privileges to that user Once the OS user exists, you grant database privileges: Grant connect privilege db2 "GRANT CONNECT ON DATABASE TO USER testdb2" Optional: Grant other roles if assinged in source db. For example: db2 "GRANT MAXIMO_READ ON DATABASE TO USER db2user1" Etep 4. Update the .bash_profile on the server with db2profile location. [testdb2@hostname ~]$ cat .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi . /opt/mano...
