473,387 Members | 1,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

how to grant only select access to a user on DB2 9.5 on windows 2008

Hi,

I have db2 instance created as an administrator on db2 udb 9.5 on windows 2008.

There is no SYSADM_GROUP defined. I want to create a user with only select access on the database and does not have any other authority and privileges except for connect.

I tried the below:
revoke the createtab,bindadd,connect,implicit_schema etc from public.
create a group and add it to SYSADM_GROUP

despite of performing other steps i am unable to see the SYSADM authority enabled to any users whom i add as member of group in SYSADM_GROUP and
I am unable to remove the indirect sysadm authority from the new user with select access only despite i have revoked everything from public and add a new group as SYSADM_GROUP in DBM cfg.

My intension is:
1.) to remove the SYSADM from public without hampering the necessary privileges from application user.
2.) to add a new group to SYSADM_GROUP so that which ever group is added to the SYSADM_GROUP in DBM cfg has SYSADM authority.
3.) create a role instead of groups with specific privileges so that any new non-administrator user can be granted these specific privileges.

Could someone please help me to achieve the above.

Thanks and Regards,
Rachana
Aug 14 '11 #1
0 1478

Sign in to post your reply or Sign up for a free account.

Similar topics

5
by: Klemens | last post by:
Hi, select user from table will return the token user what can I do to get the information from the column user Thanks Klemens
3
by: Simon East | last post by:
We recently upgraded from Windows 98 to Windows XP (clean install), but still required to edit Access 97 databases and so have kept Access 97. We installed Word XP and Excel XP, then Access 97. ...
0
by: JMCN | last post by:
Hello - I'm currently converting all of the databases from Access 97 to Access 2003. I have been ftp-ing reports from one server to another. The code was written by Dev Ashish from...
1
by: zeus | last post by:
Hi there, I am using Postgresql 7.3 and I want to grant select rights to a user on all tables in a schema, including those that may be created in the future but whose names are not yet known. I...
5
by: c676228 | last post by:
Hi, I guess I am confused. In aspx script, I mean (you won't use Codebehind="enrollinfo.aspx.vb", but mix code with html and code together) You can access user control's property directly. Since I...
1
by: shapper | last post by:
Hello, What are the release dates for Windows 2008 (with IIS 7) and SQL 2008? Thanks, Miguel
0
by: vickeec | last post by:
Hello, Does anyone know how to join a windows 2008 CORE server to a workgroup? I've attempted it with WMIC and these instructions provided by Microsoft - computersystem where...
4
by: =?Utf-8?B?QXZhRGV2?= | last post by:
ASP.Net 2. We are migrating to Windows 2008 64 bit Server with IIS 7 from Windows 2003 32 Bit with IIS 6. A few library classes we wrote uses impersonation in code like explained in this...
0
by: Jason7899 | last post by:
hi, i have the windows 2008 standard edition and i want share my fax services to the other pc´s of my network i have done this with small bussiness 2003 and so far i remember i simple install...
4
by: garethharvey | last post by:
we are moving our site to a Windows 2008 server (currently on Windows 2003), I am having problems with session cookies. Any page that is protected with a session cookie is producing the following...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.