Solved

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

Posted on 2011-02-28
3
834 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

No single Antivirus application (despite claims by manufacturers) will catch or protect you from all Virus / Malware or Spyware threats. That doesn't stop you from further protecting yourself however - and this article is to show you how.
Many of you may be aware of the recent Google Docs scam emails that have been floating around coming from various people that you know. Here's a guide on identifying How To Identify the Scam Email You will see an email from someone you’ve had co…
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…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

751 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