Adding USer(userids) to ROLES in DB2 UDB v9.5


We have just embarked on using ROLES (without any formal training) to manage access to our database/tables. As silly as this may sound, I am unable to find any example of how to do that. For exampl, we have a read only role category called ABCDUSERS_R and I want to add users to this role. What is the syntax to accomplish this task?

As always, any help will be appreciated.
Okonita001Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Okonita001Author Commented:
momi_sabag,

You are the man. It worked for me. I thank you!

okonita
0
 
Okonita001Author Commented:
The link was the source for solving my problem.

Thanks a million!
0
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.