How to add a new Linux user with db2 access
1 2 |
--Create a new user mkuser id=5000 pgrp=db2iadm2 groups=staff home=/home/jbond |
1 2 |
--set the password passwd jbond |
1 2 |
--Login into the user account su - jbond |
1 2 |
-- open the profile file to associate the db2 account to the new user vi .profile |
1 2 3 4 |
-- paste this in there and save if [ -f /home/db2inst2/sqllib/db2profile ]; then . /home/db2inst2/sqllib/db2profile fi |
1 2 3 |
-- exit the account and login again so the changes could take affect exit su - jbond |
If you need to grant the JBOND user certain privileges, the privilege assignment can be found here: http://www.simplexanswer.com/2015/08/how-to-add-a-new-linux-user-with-db2-access/