Solved

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

Posted on 2011-02-28
3
835 Views
Last Modified: 2012-05-11

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
Comment
Question by:Okonita001
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 250 total points
ID: 35003013
0
 

Author Comment

by:Okonita001
ID: 35011616
momi_sabag,

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

okonita
0
 

Author Closing Comment

by:Okonita001
ID: 35045996
The link was the source for solving my problem.

Thanks a million!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Justin
In light of the WannaCry ransomware attack that affected millions of Windows machines, you might wonder if your Mac needs protecting. Yes, it does and here is how to do it.
With the rising number of cyber attacks in recent years, keeping your personal data safe has become more important than ever. The tips outlined in this article will help you keep your identitfy safe.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Suggested Courses
Course of the Month10 days, 5 hours left to enroll

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question