[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 841
  • Last Modified:

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.
0
Okonita001
Asked:
Okonita001
  • 2
1 Solution
 
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

Featured Post

KuppingerCole Reviews AlgoSec in Executive Report

Leading analyst firm, KuppingerCole reviews AlgoSec's Security Policy Management Solution, and the security challenges faced by companies today in their Executive View report.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now