Dear all,
i am using db2 9.1(linux),
aprat from db2inst1, i want to create another user with limited priviliges,
pls help me out.

i created one user namely brcp and i add tat user to db2grp1 , i tried to login through that user and executed db2 command
it is db2 is not found ??
i am unable to found .profile in /home/db2inst1

1)what are the additional activites i have to do???


2)GRANT DELETE ON TABLE SCHEMA_NAME.TABLE_NAME TO USER RAMU

2a)before running above command what are activities i have to perform on user RAMU
2b)from where (Root or db2inst1 and path ) i have to run the above command???

DB2 uses operating system authentication. You must add the user via a Linux command such as the useradd command. The home directory of If you have questons about this, contact a Linux system administrator or a Linux forum.

If you already created the new Linux user account with with useradd, you will probably want to copy the .bashrc and .bash_profile files from db2inst1 to your new user home directory, assuming you are using the bash shell (default shell for Linux).

Thankuuuuuuuuuuuuu sooooooooo much Marcus, its working fine .....

I would NEVER do that :
you will probably want to copy the .bashrc and .bash_profile files from db2inst1 to your new user home directory, assuming you are using the bash shell (default shell for Linux).

if db2inst1 needs some specific settings, these will also be set for the other userid
the best would be to create a user instance for this user, so he will get his own profile and settings and will be independant from db2Inst1