Solved

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

Posted on 2011-02-28
3
827 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
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
momi_sabag earned 250 total points
Comment Utility
0
 

Author Comment

by:Okonita001
Comment Utility
momi_sabag,

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

okonita
0
 

Author Closing Comment

by:Okonita001
Comment Utility
The link was the source for solving my problem.

Thanks a million!
0

Featured Post

Superior storage. Superior surveillance.

WD Purple drives are built for 24/7, always-on, high-definition security systems. With support for up to 8 hard drives and 32 cameras, WD Purple drives are optimized for surveillance.

Join & Write a Comment

This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
This article explains in simple steps how to renew expiring Exchange Server Internal Transport Certificate.
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now